Forum Discussion
Power BI Service Dataset Refresh Error - Expression.Error: The column '<ccon>ID' of the ...
--------- UPDATE 9th Oct 2023 - Refreshes failing again with empty tables from 9th Sept udpate -------------- So, it seems it started to fail again as of the 9th September. Same issue exa...
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.