Forum Discussion
Power BI Service Dataset Refresh Error - Expression.Error: The column '<ccon>ID' of the ...
I have also just had this exact same issue. Without any prompt or changes on our end, we started getting this same error on some of our datasets over the weekend.
I tried leaving the 'ID' column in my dataset, and that worked for removing the error for one table. But then I just got the same error on a different table in the same dataset. I tried the same approach on that table but it doesnt appear to have fixed the issue this time.
I presume Microsoft have made some sort of change and it's messed things up a bit. Does anyone have a solution that doesnt require me to re-build my dataset? 😫
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.