Forum Discussion
Power BI Service Dataset Refresh Error - Expression.Error: The column '<ccon>ID' of the ...
Just wanted to post my update
I was able to get the error to go away for my workbooks by ensuring that the ID column coming from my SharePoint Online lists were included in the data models for each report (even though the ID field isn't used anywhere). Each time I got ID error I went through the affected table in Power Query and let the field flow through. Eventually this led to successful refreshing.
Add'l info for context
- the affected workbooks contained various data source connections to SPO, excel and even a DB. The only tables I had issues with were the ones connected to SPO.
- Both SPO connections use implementation 2.0
- There were no recent credential changes or report enhancements that would have changed my workbooks
Let me know if I can help at all!
What needs to made clear is that this is only a workaround and not a fix - Microsoft still needs to address the root cause of this problem.
Agreed
I posted about this thread in the Issues forum and they are currently testing a fix for deployment according to the MS rep on that thread.
