Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
hi all,
I want to load data from 1 table object in excel file into power bi. In the Navigator, it shows a long list of objects which is not in the excel file, i try to find the table object that i want to import but it is not in the list
Do you have any idea what is happening ?
thanks
@ktt777 is your Excel table actually formatted as a named table within the Excel file? Or is it just a standard range on a sheet?
Screenshots would help discern what is going on...
i have a table name "LALA"
Hi @ktt777
Is your table "LALA" empty? This issue may be caused by power bi couldn't identify your data model.
I have a test, I build an empty table named "LALA", and connect to this excel in Power BI Desktop.
It works well. My desktop can find this table.
You can try to rebuild the table and keep the table format by default and try again.
For reference: Connect to Excel in Power BI Desktop
Check the version of your desktop, and download the latest version: Download.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |