Forum Discussion

sulleyinoz's avatar
sulleyinoz
Advocate II
3 years ago

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...
Need Help
PEM406's avatar
PEM406
Regular Visitor
3 years ago

Same issue here, so I was very glad to find this thread.

 

I have two SharePoint lists with implementation method 2.0, neither of which are empty nor have they had any fields removed. Both still have the ID fields.

 

I can refresh the desktop version and republish succesfully but it's the dataset refresh in service that keeps failing with the same error. I've published under different names, into different workspaces and even rebuilt the queries and reports from scratch. The refreshes all work from desktop and re-publish successfully but the service refresh fails. 

 

"Expression.Error: The column '<ccon>ID' of the table wasn't found.. ID. </ccon>. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. "

  • sulleyinoz's avatar
    sulleyinoz
    Advocate II
    3 years ago

    PEM406  

     

    That's interesting ... so you're suggesting it may be something to do with the legacy sharepoint lists rather than the empty or missing ID field in Power Query.

     

    Hmmmm .... this would be true with my scenario as well, since we tested a brand new sharepoint list that was empty and it went through fine.