Forum Discussion
Power BI Service Dataset Refresh Error - Expression.Error: The column '<ccon>ID' of the ...
Could it be possible that Microsoft have suddenly changed something ...
I just did a test in PowerBI ... added some data to an empty table ... and it went through (as in that table no longer appeared in the error message but the next empty table did). And to be clear, it still means the Power BI Service Refresh fails.
So it appears only my empty tables are throwing up with this error.
Is there a global flag to not error on empty tables?
And every time I run this it comes up with a different 1 of my 93 tables that has the error. Definitely not the dataset or the data, this is something in PowerBI. My next step is to publish the same Dataset under a new name into PBI Service and see if that works.
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.