Referenced Entities - Dataflow

[mandy5118]

Is there a way to NOT have the dependent dataflows which are using a table from the upsteam dataflows as referenced entities, to NOT START the dataflow refresh.

By default the moment you refresh DF1 the DF2 with the ref. entitity starts to refresh and I know its by design. But in my case there are other components which require DF1 to fininsh refreshing. I know I can disable the load, but that would mean the entire table loads again which I dont want.

I tried power automate but there is just the option to delay/finish the DF1. That does not solve my purpose. 

Thanks

Mandar

[mandy5118]

Thanks, I posted it in the forum

[Anonymous · Accepted solution]

Hi @mandy5118 ,

I'm afraid I can't think of any other way to more easily achieve your desired results. If possible, you may want to separate the data streams so that they are not dependent on each other. This would allow you to refresh them independently, but depending on your data architecture, this may not be feasible.
Alternatively, you can try to programmatically control the refreshing of the data streams using the Power BI REST API. You can write a script to refresh DF1 and start refreshing DF2 upon successful completion.
As a last resort, you can manually refresh dependent data streams after ensuring that the upstream data stream has completed its refresh. This is the least automated method and requires manual intervention each time.

BTW, this is the Power Query forum, and based on your description your question seems more appropriate for posting in the Date Factory forum rather than here. Please post here for more specialized help:
Data Factory forums - Microsoft Fabric Community

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.