Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Adding another question on top of it.
Please, if someone has come across this provide your findings.
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.
@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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.