Power BI "Load was cancelled by an error"

[sean123]

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.

[Anonymous]

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 · Accepted solution]

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

1

2

3

Hope that helps!

Best regards,

Tim