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...
The problem happens for me in the desktop as well. At this point, I can't even choose the SharePoint list because if fails at that step (Navigation). This issue seems tied to the age of the list. I created a new list by copying an existing list and it doesn't even allow me to remove the ID column because it fails on the navigation step. I get the error immediately when I select the list name.
However, when I create a new blank SharePoint list, I don't have the problem.
If someone could please let us know how we could change the old list to make it work, that would be wonderful. I really don't want to spend hours recreating every list and I don't want to disrupt ongoing activities.