Connect to Data in Excel Table not Sheet

[simp]

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

[MarcelBeug · Accepted solution]

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).

[MichaelHalling]

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

[MichaelHalling]

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. 

[simp]

Hi @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)