Forum Discussion
Power BI Service Dataset Refresh Error - Expression.Error: The column '<ccon>ID' of the ...
The error message means, the column "ID" has been removed from one of the table that you were using.
If you are not using that column, download the PBIX file and just refresh it in your desktop and upload it again; That should work.
All the best.
Please mark this as answer if this worked.
Hi avinaash
I wish it were that easy, but nothing was removed - especially the ID column, which you cannot remove from a SharePoint List datasource.
It definitely seems #Microsoft has done something here - otherwise it is unexplainable?
Sorry, I meant to say the first thing I did was a dataset refresh using Power BI Desktop - it worked fine
I re-published the dataset, and the next Power BI Service refresh failed with the same error.
We are facing the same refresh error in our organization. I assume this is a global issue ...
I resolve that in the following way:
You have to set your ApiVersion to 15. Of course, it cannot be so simple because the table's structure will be slightly different afterward.
Hi Wojnar
I'm using the new implementation method 2.0 which has been wonderful and fast these last 6 months. Is this going to destroy that?
When you say set the ApiVersion to 15, where are you doing that? For every table in the Source script? I have 93 tables, I don't fancy doing that.
I've also checked every table still has its ID column, so this is definitely something else going on here.
Experiencing same issue since Aug 12th. Any clue so far on the fix without making major change to the model?
This could be totally unrelated, but I did have similar symptoms (I could refresh on my desktop, but not in the cloud workspace). For some reason my Data Source Credentials (in the cloud workspace) were changed from Organizational to None. Once I changed them back, my refreshes started working again. Just a shot in the dark. Maybe it can help.
I'll double check, but I've redone the credentials multiple times during the tests with the MS Customer Service Rep, so doubt that's this main problem. Cheers
