Source from a variable range in a worksheet

[FCD]

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 range into a table.

Thank you for your help.

Best Regards

[Anonymous]

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

[m_dekorte]

Hi @FCD 

Create an Excel Named Range. That can be made dynamic, with worksheet functions: OFFSET and COUNTA or INDEX and COUNTA. Next use Excel.CurrentWorkbook in Power Query to get the contents from that range.

I hope this is helpful