Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Kiven03
Frequent Visitor

Error loading data from local file (Excel)

Kiven03_0-1712042629127.png

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 shows this kind of error and I really don't understand what to do.

 

Please provide me with any solution.

Thank you in Advance,

Vivek

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

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

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.