Forum Discussion
Data Flow Refresh - merged tables
Hi , filiparibeiro
According to your case description, you are using the feature of the linked entity of Power BI dataflow, and according to my research and search in the official documentation, this feature requires a workspace in the Premium capacity to unlock the normal refresh of the dataflow, check out this official documentation:
Link entities between dataflows - Power Query | Microsoft Learn
In addition, as Collinq said, Premium capacity brings you more benefits than just the unlocking of dataflow refreshes, there are many limits on larger resources and wider maximum limits, depending on the type of SKU you subscribe to, check out this official document:
Power BI Premium features. - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
HI filiparibeiro ,
There are many benefits to having Premium besides this but if you don't have the need for Premium other than for this one thing I would suggest the following workaround. Create a Dataflow that gets your two tables. Then create a SECOND Dataflow that reads the results of the first dataflow. In the second dataflow, uncheck enable load on the two tables, and then you can merge them into the 3rd query and have only the 3rd query enabled to load. The key here is to make sure that you have the second dataflow refreshing after the first dataflow is DONE refreshing, or you don't get much of a result.
Thanks for your reply. Would premium per user version solve this issue?
Hey filiparibeiro ,
Without knowing all the variables, it is hard to give a definitive "yes, Premium will solve this" so my suggestion is that get a PPU license and see if that works for your user. If so, then you can roll out Premium and have all the developers (and users) use Premium.
