Forum Discussion
Power BI Service Dataset Refresh Error - Expression.Error: The column '<ccon>ID' of the ...
Can confirm this issue is occurring for us as well. Dataset refreshes fine on Desktop, showing identical refresh error in web. Seems to be at Microsoft end. Interestingly, we are using the same Cluster URI as OP:
- Cluster URI: WABI-AUSTRALIA-EAST-A-PRIMARY-redirect.analysis.windows.net
Coincidence?
EDIT: Even though the desktop app is allegedly refreshing, it appears to be missing the latest data from the source (a Sharepoint List)
I am also facing the similar issue, it started all of a sudden with Sunday morning(Sydney Time)
Data source error: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. Table: xxxxxxxxxxxxxx
| Cluster URI: | WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net |
| Activity ID: | e513f0c6-4221-4471-95b3-41da5ae373a5 |
| Request ID: | e5e969ae-07c7-410b-844d-54ad808bb5a7 |
| Time: | 2023-08-12 22:24:26Z |
The Table Name also changes with each of the scheduled refresh.
The refresh works fine with the Desktop version. Not sure what's causing the issue.
Current Workaround is to refresh the in desktop version and publish it again. But scheduled refresh fails again and again. I guess this is a widespread issue with Microsoft Fabric.
Experts are welcome to comment.