Forum Discussion
Event Based trigger to refresh Power bi Datasets
Hi Friends
I have a requiremnt where the datasets of power bi should refersh automatically once the ETL loads are completed.
Hi Angadi ,
You can do that with the ADF pipeline or power automate.
No need to wait for scheduled refresh to occur - Automate the refresh of Power BI Dataset on Service just after the completion of ETL.
https://www.linkedin.com/pulse/need-wait-scheduled-refresh-occur-automate-power-bi-magan-sachdeva?utm_source=share&utm_medium=member_android&utm_campaign=share_viaIf you were able to receive a email once the ETL process is successful then you can check this approach.
Thanks,
Sai Teja
Have the ETL send an email or post a file to sharepoint on successful completion.
Use Power Automate triggers to react to these. Then in the Power Automate flow request a dataset refresh.
Obligatory caveat: Requesting a refresh is asynchronous. It's just a request. Power Automate will not wait for the completion of the refresh. You need to build your own monitoring process for that.
2 Replies
Hi Angadi ,
You can do that with the ADF pipeline or power automate.
No need to wait for scheduled refresh to occur - Automate the refresh of Power BI Dataset on Service just after the completion of ETL.
https://www.linkedin.com/pulse/need-wait-scheduled-refresh-occur-automate-power-bi-magan-sachdeva?utm_source=share&utm_medium=member_android&utm_campaign=share_viaIf you were able to receive a email once the ETL process is successful then you can check this approach.
Thanks,
Sai Teja
Have the ETL send an email or post a file to sharepoint on successful completion.
Use Power Automate triggers to react to these. Then in the Power Automate flow request a dataset refresh.
Obligatory caveat: Requesting a refresh is asynchronous. It's just a request. Power Automate will not wait for the completion of the refresh. You need to build your own monitoring process for that.