Forum Discussion
Power BI Service Dataset Refresh Error - Expression.Error: The column '<ccon>ID' of the ...
I'm getting the same across multiple tenants for reports refreshing since 9th August.
In my case a workaround is to not remove the ID column in Power Query and let it come through as-is to the data model. It's usually not being used for anything on the reports I run so I've stripped it out of reports but putting it back in and publishing to service fixes that. It only works if I bring through the actual ID column, I can't just rename another column to ID, so I guess it's trying to do something when it hands data from PQ to the data model and assumes the SharePoint ID column will be present?
I have the same issues appearing in more than one report at the moment. I'm able to refresh both reports in desktop without any issues, and as far as I can tell the ID column isn't being used anywhere. I can confirm that the source tables in my reports all have data in them, and each source currently resides on SharePoint Online. Neither report has had this issue in the past, so I'm assuming something has changed on Microsoft's end. Please let me know if you or sulleyinoz find a solution!