cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Email to customer AFTER Power BI finishes to refresh

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Email to customer AFTER Power BI finishes to refresh

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

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Email to customer AFTER Power BI finishes to refresh

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.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Highlighted

Re: Email to customer AFTER Power BI finishes to refresh

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,483)