Forum Discussion
Power BI Service Dataset Refresh Error - Expression.Error: The column '<ccon>ID' of the ...
Hi sulleyinoz ,
Have submitted this issue internal to confirm, would update here as soon as possible if there is any update about it.
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
- Its better to delete the unnecessary references to these column IDs in the data transformation steps.
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.
