Forum Discussion
Problem refreshing Power bi
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.
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.