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?
Experiencing the same issue since Aug 12. Desktop refreshes no problem, but Power BI Online throws the error 'The column '<ccon.ID' of the table wasn't found'. The report that failed is using Implementation="2.0". Saved a copy of the report, deleted and re-added the SharePoint Online list using Implementation 1.0 and the refresh was successful in Power BI Online.
Waiting to see if Microsoft can come up with a fix before tearning down and rebuilding many reports.
Also, the Fabric icon now appearing in Power BI Online. Don't recall seeing it last week.