Forum Discussion
Helper IConnect to Data in Excel Table not Sheet
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).
Community ChampionFirst 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).
Helper IHi 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)