Forum Discussion
Dataflow Merge in Service Causes Refresh Failure
I loaded two Execel files to Sharepoint and brought them into Dataflows in app.powerbi.com. I did a merge (not as a new table) on one of my queries and the refresh failed. I get the following error m...
HI noahshor ,
AFAIK, some advanced operations not works on power bi service side.(e.g. reference, merge, invoke custom functions) I think your issue should related to it.
>> Why is it that when I try to do merge on an exisiting table, it fails but works when I merge into a new table?
It should related to new computed entities feature which allow you to do some advanced operations on dataflow side.
Using computed entities on Power BI Premium
Regards,
Xiaoxin Sheng