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?
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.
In my case none of the table is empty. But still facing the refresh issue on the online but working fine on the desktop version