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
AustenE's avatar
AustenE
Regular Visitor
3 years ago

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)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.