Forum Discussion
MySQL Fatal error encountered during data read
Hi Anonymous ,
Based on an internal search, the following information is obtained:
cannot be found or may not be used in this expression.
Column '<ccon>[content removed]</ccon>' in table '<ccon>[content removed]</ccon>' cannot be found or may not be used in this expression.
{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError"
It is possible that one of your columns may have been renamed or removed from the data source, resulting in an error when you cannot find the column when using M or Dasx expressions.
You can go to the Power Query file to check whether each table can be refreshed successfully, the table that cannot be refreshed is the table with the problem, after finding the problem table, you can find the relevant column, and then change the column name.
This is the related document, you can view this content:
Expression.Error: The column '' of the table wasn'... - Microsoft Power BI Community
Solved: Column cannot be found or may not be used in this ... - Microsoft Power BI Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Liu Yang,
I've confirmed that columns are the same in database (I refreshed the SQL a few times). However, is it possible that I have this error because I renamed database columns in Power Query?
Thanks,
Marc