Forum Discussion
Power BI Service Dataset Refresh Error - Expression.Error: The column '<ccon>ID' of the ...
In case it's of any help to anyone in indentifying and fixing the issue. I've noticed that the only tables in my datasets that are having this refresh issue are the ones that have 'Choice' type columns in. All other tables (newer or older than those tables) that don't include 'Choice' type columns aren't having any trouble refreshing in the service.
Further to the above - as many have identified, a short term fix of keeping the ID column in the table works around the issue.
I have also identified that anywhere you use the table causing the issue in a merge with another table, you also need to include the ID column (i have several instances of this). So i was able to completely resolve the issue by going through all the tables where the original table was included in a merge and keeping the ID column. This os obviously not ideal. But may buy you some time buy getting your flows running correctly until MS fixes the issue.
I will be lodging a ticket with MS today as suggested to help highlight the issue.