Forum Discussion
Power BI Service Dataset Refresh Error - Expression.Error: The column '<ccon>ID' of the ...
I beleive this is a widespread issue, something has suddently changed at Microsoft's end, in terms of how the refresh deal with a Sharepoint List.
Would be great if everyone having the issue can rais a ticket with microsoft and refer to this thread too.
I've spent nearly 4hrs troubleshooting with Microsoft, doing single table tests, single empty legacy table tests, single table new tests, gateway tests etc ... all to no avail to fix the issue yet.
I haven't followed up with them this afternoon, but will do so shortly to check on progress. They need to know this is much wider than just me. I just happened to spot it overnight on the first night it happened.
Cheers All
Hi everyone, I was facing the same problem.
My query uses the 2.0 implementation, and the ID field was not loaded in the query steps.
I changed my 'other columns removed' step so that the ID field was not removed and this solved my problem.Thanks sulleyinoz and all for the help.
Thanks for posting the solution AlanCruz! Changed the step to un-remove the ID column (2.0 implementation) and the refresh now works in the browser.
That's great and good proof that with the ID field included in the Power Query and with data in the list, it should work and go through the refresh!
