Forum Discussion
Power BI Service Dataset Refresh Error - Expression.Error: The column '<ccon>ID' of the ...
UPDATE
So, a ticket is raised with Microsoft, I spent an hour and a bit on a support call. And so far we have determined the following:-
- Sharepoint List (classic teams site) to Power BI Dataset via Implementation 2.0 connector with empty list will create the error
BUT, a brand new empty list created in the same site works fine ... i.e. new one just created as empty, worked.
So it seems there is an issue with legacy lists that are empty with PowerBI Service refresh.
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?