Email automation

[Anonymous]

Hi,

I would like to set up an email notification through powerautomate after the sematic model of power bi is updated. May I please ask exactly how to do this. 

Thanks

[lbendlin]

No such trigger exists. You need to implement your own polling process.

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Because it is necessary to obtain the status of data refresh in real-time, it may be necessary to combine the Power BI rest API. Then, when the conditions are met, you can trigger your subflow which includes the action ‘Send an Email’. You can refer to this forum reply first.

Solved: Refresh a dataset not waiting until refresh comple... - Power Platform Community (microsoft.com)

Regarding how to call the Power BI rest API in Automate, please refer to this document ‘HTTP’ action.

HTTP actions reference - Power Automate | Microsoft Learn

For the Power BI rest API used to monitor the refresh status of the PowerBI dataset, please refer to this document.

Datasets - Get Refresh History - REST API (Power BI Power BI REST APIs) | Microsoft Learn

For information on how to create and invoke subflows in Automate, please refer to this official document

Create child Flows - Power Automate | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.