Dataflow Merge in Service Causes Refresh Failure

[noahshor]

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 message:

Error: An internal error occurred... RootActivityId = e600e75b-60b7-48bf-b451-3a7962d0b852.Param1 = Information about a data source is required. Request ID:

I changed the privacy settings to each option (Organizational, Public, Private, None) and it still continues to fail during refresh. However, when I do a merge as a new table, the refresh works. 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?

Thanks!

[v-shex-msft]

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