Forum Discussion

FCD's avatar
FCD
Regular Visitor
2 years ago

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

 

Thank you for your help.

Best Regards

Need Help

2 Replies

  • m_dekorte's avatar
    m_dekorte
    Resident Rockstar
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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