Forum Discussion
Power BI Scheduled Refresh Error: Data source errorThe 'BU-BL' column does not exist in the rowset.
Dear Community,
after getting this error, I noticed the owner of the original table in Sharepoint to which my Power BI data model is linked has deleted the column with name 'BU-BL'. So, I just edied my DAX codes in Power BI desktop by deleting the column name 'BU-BL' from the code. Then, I republished my Power BI report to my workspace, replacing the one with the error. However, my scheduled refresh is still having the same error message. Please, can anyone help? Thank you.
11 Replies
- Idrissshatila
Super User
Hello Anonymous ,
also check power query, it may be referenced in any step and this would also make an error.
Hello Idrissshatila
yes, I checked power query and edited the DAX code in power query. I made sure all the queries finished without an error. All the queries that indicated the error also mentioned the 'BU-BL' column no longer exists, which I deleted. However, the scheduled refresh is still showing the error message, but the power query has no error.
- Idrissshatila
Anonymous ,
did you publish this new edited power bi file to replace the old one ?
