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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sean123
Frequent Visitor

Power BI "Load was cancelled by an error"

Hello.

I am a new user of Power BI I have have the the below error messages. I have read the previous solutions however I do not know where to find the M code or other technical solutions mentioned. Unfortunately that start at a level above me. Would it be possible to suggest a solution to a complete novice please. Many thanks.

 

sean123_0-1612728834453.png

 

1 ACCEPTED SOLUTION
timg
Solution Sage
Solution Sage

Hi Sean,

This likely means that one of the columns you are using ('Column12') cannot be retrieved from the source. The reason for this is most likely that this column does not exist in the source anymore, or that one of the steps in your query is not correct. To troubleshoot you can go to the power query screen by pressing "transform data" (image 2). in the power query editor you can see your queries on the left. the table containing the error should have an exclamationmark in front of it (image 3). From that point you'll basically have to check trough the query steps to see where and why the issue starts occurring (image 3). 

11

22

33

Hope that helps!

 

Best regards,

Tim





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
v-rzhou-msft
Community Support
Community Support

Hi @sean123 

According to the error message, you might have some steps that reference the column 'Column12' which has been removed or renamed or any other operation when you modified the query. It could be a step where you renamed, re-ordered columns, changed data types, removed other columns, etc.

 

Directly, right click on your query then select Advanced editor. Here you can see the name of columns/object used for each step of your query, find the unfound column name and edit it. 

 

And I found a post with issue like yours, I hope it could help you.

Post: Expression.Error: The column '<ColumnTitle>' of the table wasn't found

 

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. 

 

timg
Solution Sage
Solution Sage

Hi Sean,

This likely means that one of the columns you are using ('Column12') cannot be retrieved from the source. The reason for this is most likely that this column does not exist in the source anymore, or that one of the steps in your query is not correct. To troubleshoot you can go to the power query screen by pressing "transform data" (image 2). in the power query editor you can see your queries on the left. the table containing the error should have an exclamationmark in front of it (image 3). From that point you'll basically have to check trough the query steps to see where and why the issue starts occurring (image 3). 

11

22

33

Hope that helps!

 

Best regards,

Tim





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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