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 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
Solved! Go to Solution.
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 :
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
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 :
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
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
69 | |
68 | |
40 | |
29 | |
26 |
User | Count |
---|---|
89 | |
49 | |
44 | |
38 | |
37 |