Automatically Refresh Dataset after Dataflow refresh completes

[Anonymous]

Hello Power People,

I have a Dataflow and a Dataset created from the same Dataflow. 

I want the Dataset to be refreshed automatically after the Dataflow refresh completes where I'll set the schedule refresh for the Dataflow. Can we write some kind of script, or python code to achieve this? Please help. 

Thank you in advance from India. 

Regards,

Anirban

[Devender28]

Adding another question on top of it. 

1. Let's say if my Dataflow takes 2 hours to finish the refresh. 
2. when i refresh Power BI refresh does it eliminate the above 2 hours and does the rest or does it include above 2 hours + Rest. 

Please, if someone has come across this provide your findings. 

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Please refer to the link, two solutions are provided here.

The first method is to first estimate the time required to refresh the dataflow, and then set the time point for refreshing the dataset.
The second method is to use Power Flow.

Trigger Automatically the dataset refresh after dataflow refresh is done 

Refresh your Power BI dataset using Microsoft Flow 

Best regards,
Lionel Chen

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

[amitchandak]

@Anonymous , refer if these can help a bit

https://radacad.com/how-to-use-dataflow-to-make-the-refresh-of-power-bi-solution-faster

https://powerusers.microsoft.com/t5/Building-Flows/Refresh-Power-BI-DataFlows-with-Flow/td-p/385778

https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/