Forum Discussion
Helper IConnect to Data in Excel Table not Sheet
Hello,
Whenever i try to connect to my excel file, it shows all range from A1 to end,
I want to connnect to data in specific table range name,
Is it possible, and how to do it
Thank you
First get your definitions clear.
A range is not the same as a table.
So first create your named range of - better - your table in your Excel workbook.
Save the workbook.
Connect to the workbook (using "From Excel"), which will give you a list of usable objects, including your table (or range) and the worksheet(s).
Now drill down to the table (or range).
4 Replies
- MarcelBeug
Community Champion
First get your definitions clear.
A range is not the same as a table.
So first create your named range of - better - your table in your Excel workbook.
Save the workbook.
Connect to the workbook (using "From Excel"), which will give you a list of usable objects, including your table (or range) and the worksheet(s).
Now drill down to the table (or range).
simpHi MarcelBeug
Thank you for your feedback,
This is wierd,
Today i can see the table category (not just sheet)
So, problem solved
Thank you
update: i realized that this is because my file is protected with such DRM so the table category is not showing (i must open it first to have acces to the file from pbi)
Hi MarcelBeug ,
For some reason I do not get a list of my tables from the excel sheet. Would you mind posting the generated M code for how it connects to the source?Thanks
Michael
Solved my problem:
Seems I was working with old workbook file types. After converting them to the latest Excel workbook types the tables where visible in the natigation step of Power Query.