web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Email to customer AFTE...

Power Automate

Answered

Email to customer AFTER Power BI finishes to refresh

(0) Share

Report

Report

Posted on by michaelshparber

111

Hello, my Power BI dataset scheduled to refresh 8 times a day.

I need to send an email to new customers (that are added to a SQL table) AFTER a refresh is completed.

So it goes something like:

1. Get a trigger when Power BI successfully finishes a refresh (if it is possible. If not - what are alternatives)

2. Check a SQL table if there are new customers (the EmailSent_indication field is null)

3. Email them

4. Update the EmailSent_indication field in the SQL table

What is the best way to build it?

Thank you

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (2)

Report
mmm @michaelshparber I recomment you an schedule Flow that could runs every hour and then every execution you can get your refresh POWER BI by using the API https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistory

This js the json response:

{ "value": [ { "refreshType": "ViaApi", "startTime": "2017-06-13T09:25:43.153Z", "endTime": "2017-06-13T09:31:43.153Z", "status": "Completed", "requestId": "9399bb89-25d1-44f8-8576-136d7e9014b1" } ] }

as you can see you have a propertie called status so you can use that propertie to send or not an email if some condition.

Was this reply helpful? Yes No
Verified answer

michaelshparber 111 on at

Like (0)

Report

I found the solution:
I have added a data driven alert in Power BI dashboard - and it is fired when the dataset refreshes.
In Automate I use "When a data driven alert is triggered in Power BI" trigger.
That's it.
Thanks

Was this reply helpful? Yes No
rahulstomar08 2 on at

Like (0)

Report

hi @ChristianAbata
Can you please elaborate on your point?
I'm confused about how to make flow. What should be the trigger, and what should be the action.
Please help me in this regard
Thanks,
Rahul

Was this reply helpful? Yes No

Join the conversation