Forum Discussion
Power BI Service Dataset Refresh Error - Expression.Error: The column '<ccon>ID' of the ...
I have had exactly the same issue since Saturday but with a new SharePoint list! we are not using SharePoint Classic. The fix seems to be as someone above also suggested:
- Make sure the ID column is visible on your SharePoint list in Sharepoint and at position 1 from the left.
- In the Power BI Query editor, you will find a step has been added to remove the ID column, remove this step or reference to the ID column from this step so that it is not deleted from your data model for any SharePoint list.
- Republish your report and refresh should work again for now!
Hope this helps, although very annoying that MS has obviously made a change that has a significant impact without understanding the implication of the change made before implementation.
I agree, this also seems to have worked for me.
I'm using Sharepoint online lists and merging data from them both. I've just added the ID from both tables back into the query. This seems to work; at least triggering a manual refresh after publishing has worked when previously it had failed every time.
As I'm merging the data from two lists, most rows then retain the ID from the primary list but in some cases I have rows that only appear on the secondary list. In those case I've multiplied the ID in the secondary list by 1000 to avoid the risk of duplication and then used a conditional column to merge the IDs from the two tables. I then deleted the original ID fields and renamed the conditional column to ID so there's only one ID field in the published query/report.
As mentioned, annoying that a change like this wasn't announced and we've had to re-do work to resolve it.