Dataflows with Power BI Pro cant Append Queries (Computed Entity)

[DebbieE]

 Even more serious issues with the dataflow with Power BI Pro

I cant even merge queries. it becomes a computed Entity and only available in Premium. 

This means I cant Append, I cant Merge and I have to duplicate instead of creating reference tables. This is fairly huge. I need to do these things to get my data in place before moving to the data set. Am I going to have to backtrack and tell everyone that they cant use dataflows and they need to do it in the pbix file if they want to actually turn there data into decent data models. (I certainly can do this with these restrictions in place)

[Kirt1965]

These solutions no longer work.  Even when both sources are not loaded, if the final result is loaded then it is computed and does not work.

[v-yiruan-msft]

Hi @DebbieE ,

Please check the workarounds in the following posts can help resolve your problem.

Merging tables in Power BI dataflows with PRO subscription

Workaround for Computed Entity in Power BI Pro: Dataflow in Power BI

Best Regards

Rena