Forum Discussion

simp's avatar
simp
Helper I
9 years ago
Solved

Connect 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
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

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

MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

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's avatar
MichaelHalling
Frequent Visitor
6 years ago

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's avatar
    MichaelHalling
    Frequent Visitor
    6 years ago

    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.