topic Re: Send Email to Report Users when Report is Refreshed in Report Server

Send Email to Report Users when Report is Refreshed

katmaher_1 — Tue, 17 Nov 2020 18:21:19 GMT

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!

Re: Send Email to Report Users when Report is Refreshed

lbendlin — Wed, 18 Nov 2020 02:47:21 GMT

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

Re: Send Email to Report Users when Report is Refreshed

DavisBI — Wed, 18 Nov 2020 16:10:19 GMT

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.

Re: Send Email to Report Users when Report is Refreshed

Anonymous — Mon, 16 May 2022 09:59:57 GMT

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

Re: Send Email to Report Users when Report is Refreshed

Anonymous — Tue, 31 May 2022 09:06:57 GMT

Hi,

how do you power automate this?

thanks in advance

Best regards

Atif

Re: Send Email to Report Users when Report is Refreshed

Elephant — Mon, 17 Jul 2023 15:34:54 GMT

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?