Send Email to Report Users when Report is Refreshed

[katmaher_1]

I have a report that willl be shared with ~300 users, but the user list will change as people enter/leave the company. I am trying to find a way to send an email via Outlook to all of the report users when the dataset is refreshed. Given the irregular nature of users being added to the report the subcription button does not really work that well to acomplish my goal. Is there a way to set up an email that is triggered on a PowerBI refresh using PowerAutomate, or is there a way to subcribe every report user to the Subcription feature in PowerBI?

Thank you and looking forward to learning new ideas/solutions!

[lbendlin · Accepted solution]

Subscription is the wrong approach as it doesn't trigger from a dataset refresh.  API based refresh requests allow you to specify when mails should be sent (default is on failure only but you can also choose to send on any completion)

Datasets - Refresh Dataset In Group (Power BI Power BI REST APIs) | Microsoft Docs

You can also monitor refresh status with Power Automate and upon completion send a mail to a distribution list

Datasets - Get Refresh History In Group (Power BI Power BI REST APIs) | Microsoft Docs

[Elephant]

Hello, I have the exact same need as the previous users.

The problem with subscriptions is that it send an email at regular intervals only (day, week, month).

I need to send an email ONLY when a report is manually published (or refreshed) and that could be anytime.

Shouldn't there be a way that can be done in Power Automate?

[DavisBI · Accepted solution]

Hi, @katmaher_1 

Are you using Power BI Report Server or Power BI Service?

For PBIRS, it can be solved through SQL Server Agent job if you using SQL Server that runs on your domain server as your report's data source. By setting a job,  whenever the dataset is refreshed, an email task can be triggered.

For Power BI Service, you can use PowerAutomate.

[lbendlin · Accepted solution]

Subscription is the wrong approach as it doesn't trigger from a dataset refresh.  API based refresh requests allow you to specify when mails should be sent (default is on failure only but you can also choose to send on any completion)

Datasets - Refresh Dataset In Group (Power BI Power BI REST APIs) | Microsoft Docs

You can also monitor refresh status with Power Automate and upon completion send a mail to a distribution list

Datasets - Get Refresh History In Group (Power BI Power BI REST APIs) | Microsoft Docs

[Anonymous]

Hi, 

how do you power automate this? 

thanks in advance 

Best regards 

Atif

[rahulstomar08]

Is there any way to send refreshed report link to the user whenever my dataset get refreshed