Event Based trigger to refresh Power bi Datasets

[Angadi]

Hi Friends 

I have a requiremnt where the datasets of power bi  should refersh automatically once the ETL loads are completed.

[SaiTejaTalasila · Accepted solution]

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?ut...

If you were able to receive a email once the ETL process is successful then you can check this approach.

https://powerusers.microsoft.com/t5/Building-Flows/Trigger-Power-BI-refresh-only-when-I-receive-SUCC...

Thanks,

Sai Teja 

[lbendlin · Accepted solution]

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.

[SaiTejaTalasila · Accepted solution]

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?ut...

If you were able to receive a email once the ETL process is successful then you can check this approach.

https://powerusers.microsoft.com/t5/Building-Flows/Trigger-Power-BI-refresh-only-when-I-receive-SUCC...

Thanks,

Sai Teja