Forum Discussion
Power BI Service Dataset Refresh Error - Expression.Error: The column '<ccon>ID' of the ...
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
Anonymous Add your default SharePoint IDs back in (i.e. don't remove them in Power Query) and hopefully that fixes your issue if your tables contain data.