Problem refreshing Power bi

[Jakob123]

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?

[Anonymous]

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.

[R1k91]

can you provide the M code behind this query?

[Jakob123]

Im a bit new to Power bi, but where can i find the m code?

[R1k91]

in pbi desktop

• transform data
• locate query
• advanced editor

that's the M code behind your query

[Jakob123]

So, since i didn't create the report its not stored locally on my computer, its on his computer which is gone.

So im assuming the way i get it into power bi desktop is downloading a editable file of the report and loading that into the desktop version.

However after doing this and going into transform data no querys are shown?

Am i doing wrong?

[R1k91]

are you sure you haven't queries in it?

in power query, table = query

[Jakob123]

Yeah, like o load the file i downloaded and press "transform data", up comes "A directquery connection is required" so i press add a local model.
Then its shown like this.

[R1k91 · Accepted solution]

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. 

[Anonymous]

My report is not refreshing the data. Someone know why? When I click on data and select the table to do a refresh, nothing is happening.

[Jakob123]

Thanks a lot guys! it now works and updates as intened 🙂 Could not have done it without you ❤️