Forum Discussion
Data Refresh - Expression.Error column not found
Hi Anonymous,
Yes, the issue might related to the "Changed Type" step. As stated in this article Data types in Power BI Desktop. When you load data into Power BI Desktop, it will attempt to convert the data type of the source column into a data type that better supports more efficient storage, calculations, and data visualization. Then when you refresh the data, there may exists some new data which don't fit the data type and cause the issue.
Also, based on my research below are some relevant threads which are talking about the same issue. Please make a reference and see if it helps.
https://community.powerbi.com/t5/Desktop/Data-Refresh-Expression-Error-column-not-found/td-p/133867
Thanks,
Xi Jin.
Hi Anonymous,
Yes, the issue might related to the "Changed Type" step. As stated in this article Data types in Power BI Desktop. When you load data into Power BI Desktop, it will attempt to convert the data type of the source column into a data type that better supports more efficient storage, calculations, and data visualization. Then when you refresh the data, there may exists some new data which don't fit the data type and cause the issue.
Also, based on my research below are some relevant threads which are talking about the same issue. Please make a reference and see if it helps.
https://community.powerbi.com/t5/Desktop/Data-Refresh-Expression-Error-column-not-found/td-p/133867
Thanks,
Xi Jin.