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?
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.
That sounds interesting .... for me ALL my ID fieds are still in the PBI Dataset and were never removed, but the timing is interesting. Around the same time something has definitely changed. Thx for that.
Ahhh after I confidently stated that would fix it I've come across a report where it doesn't so now I'm more confused than before!
Check if its empty tables or tables with data ... that's the issue I'm working through with MS. All my tables withe Data all refresh fine. But one single empty table and it blows up and the refresh fails. And it works on Desktop, but fails on PBI Service.
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!
