Forum Discussion
Source from a variable range in a worksheet
Dear All, How to specify the source of a request from a range in a worksheet. I mean I wish the source to be the range from A3 cell to E&(LastRow) from worksheet1. I would prefer not to convert my...
Hi FCD ，
Try selecting the cells in this section in Excel and then use Ctrl+T to convert this section to a table, then use PowerBI to connect to Excel you will see that the area you just selected in the navigator will be recognized as a table.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group