Forum Discussion
Send Email to Report Users when Report is Refreshed
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
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.
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?