Forum Discussion
Problem refreshing Power bi
Hello everyone!
I recently took over from a colleague at work, and now when i'm trying to update the power bi dataset it only gets back to me with the following error:
[ValidateMarkupTags][ccon]Expression.Error: The column '[ccon]Column21[/ccon]' of the table wasn't found.. [ccon]Column21[/ccon]. [/ccon]. The exception was raised by the IDbCommand interface. Table: X
The odd thing is that the excel sheet where all the data is stored is only using 20 columns, so the 21st isnt being used.
What can i do to fix this issue?
which option did you choose when downloading?
in order to see the power query you need to downalod the report and the semantic model not the live query report only.
if you chose "a copy of the report and data" and you get a live connected report it means semantic model (and M query) is somewherelse.
you can verify if your report was originally a live connected one looking to the lineage view in power bi service.
10 Replies
can you provide the M code behind this query?
Hi Jakob123 ,
This error message means that the updated record in the data source does not match the structure of the cached data.
The simple explanation is that Power Query records every previous operation and structural change in the data. When data structures are changed on the data source side (e.g., changing column names/types, editing/deleting fields), and the new records do not match these cached data structures, Power BI returns an error message about "a column is not being found".
For this scenario, you need to enter to Power Query editor to manually fix these data structure issues and publish to replace the old report.
Another possible solution is to clear the data source cache in Power BI. To do this, go to Data Source Settings in the Power BI client and clear all permissions. Then, regain the permissions again and try to load the source again.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
