Forum Discussion

Kiven03's avatar
Kiven03
Frequent Visitor
2 years ago
Solved

Error loading data from local file (Excel)

Hi All,   I worked on this data set long back (1 month approximate ). Today I have opened it, I have cleared all the errors with file path in Power Query. But later when I loaded it, it sho...
Need Help
Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi Kiven03 
You have some problems with the table Fact_marks.
Check what is the format of the file if it is XLS , change to XLSX.

If it doesn't help:

Select the query in the fields: open "Edit Query"; This will open the power query editor.
Now go to the navigation steps of that query on the right-hand side. 
Step by step - review each step in the navigation. In one of them you would find an issue (e.g. Column change etc ); the step where you can open the "Table" click on it and the Table will open.
Then Apply,  Refresh in the main Power BI screen.
You can also take a look at the linked article of Chris Webb :

https://blog.crossjoin.co.uk/2023/08/27/understanding-the-external-table-is-not-in-the-expected-format-error-in-power-query-in-power-bi-and-excel/

and the linked video :

https://www.youtube.com/watch?v=WKrs7SJ2ol0

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Kiven03's avatar
Kiven03
Frequent Visitor
2 years ago

Hi Ritaf1983 ,

 

Thank you for the help, this is really helpful to me.
But, the thing is I have managed everything long back (If I knew this video or trick it would have been very useful thing at the time).
This kind error is very new and strange. If I didn't find any solution, I will definitely use your tip and develop every from scratch.

 

Thanks you very much.