Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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).
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).
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.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |