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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

I am facing the same issues from last 3 weeks now. I have two data sets (One SAP HANA and One Sharepoint) .My report is getting refereshed in Desktop however when i am trying to refresh the report in service its getting failed.

I have checked both of the sources having same security level"Organizational" and i have updated my gateway as well. 

(Note-I have one founding that i have done merge between sharepoint and hana source and frpm that step its not refreshing the data. If i am not doing any merge between by data source and trying to refresh my data in PBI Service its happening.

Please see below screenshot of the error :

Please help if you have any idea what needs to be done.

Regards,

Ashish

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Its better to delete the unnecessary references to these column IDs in the data transformation steps.
  • sulleyinoz's avatar
    sulleyinoz
    Advocate II
    2 years ago

    So, it seems it started to fail again as of the 9th September.

     

    Same issue exactly as the original failure ... empty tables won't refresh and cause the entire refresh on PowerBI Service to fail.

     

    Desktop works fine as usual.

     

    Seriously Microsoft, I have lost a client over this refresh issue.