Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jonathan quesada]

Hello Everyone, 
                  Anyone have experience automating the process to refresh the dataset after the dataflow refresh is completed.   Does Power BI offers an option to doing so?   
                  Currently we have both scheduled at specific times of the day, but we would like to trigger the refresh as soon as dataflow refresh is done. 

——————————
Jonathan Quesada
Power BI Costa Rica
——————————

[Gregory Bounds]

Hey Jonathan,

I’d be curious as well for any solution someone has. A workaround I used was to use Power Automate. We had a dataflow refresh that took anywhere from 25-35 minutes starting at 7am. Because of that unusual time, we couldn’t assume that it would be done by 730am. So we scheduled the dataset refresh for the 7:40am using a Power Automate flow.

——————————
Gregory Bounds
Ironedge Group
TX
——————————
——————————————-

[Jonathan quesada]

Yes we do the same with scheduled refreshes in the service, but we would like to understand if there is kind of an event trigger available we can use. ?

——————————
Jonathan quesada
10905
——————————
——————————————-

[Lutz Bendlin]

I hope this question will be obsolete once direct query connections to dataflows will be available.

——————————
Lutz
——————————
——————————————-

[Jorge Sanchez]

Hi Jonathan,
As  said you can use power flows. This is a workaround including power flows and API. Trigger first the desired dataflow using the API. The response will give you a 200 but i don’t think this means that refresh was completed. so you enable the option MailOnCompletion

MailOnCompletion

string

Mail notification will be sent on refresh completion, including either failure and success

This option will generate an email and you should be able to create a flow which reads that email and trigger the dataset refresh(This option is available on Flow)
https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows/refreshdataflow
?

——————————
Jorge Sanchez
33018
Beauchamp Construction Co , Inc
Miami FL
3058634762
——————————
——————————————-

[Gregory Bounds]

Ingenious solution ?. Another reason for me to revisit the Power BI API.

——————————
Gregory Bounds
Ironedge Group
TX
——————————
——————————————-