Forum Discussion
Automatically Refresh Dataset after Dataflow refresh completes
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
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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/
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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Adding another question on top of it.
- Let's say if my Dataflow takes 2 hours to finish the refresh.
- 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.
