Forum Discussion
Send an email to users after multiple report refresh succeeded
Super UserHey,
Couple of queries before we work on a proper solution :
1) Are all the reports refreshed currently based on Power BI service schedule or is it via some other way via power automate/ADF etc?
2) Are all reports refreshed during same time in a day or during different times
Hi NandanHegde
reports refreshed in an hour time interval ,refresh started at same time but refresh completed at different time for different reports.
all reports are scheduled through power bi services.
- NandanHegde
So to achive your use cases:
1) you can leverage Power automate or any automation tools like Azure data factory to trigger the PowerBI datasets parallely via REST API and schedule the job rather than the reports refresh via powerbi service.
2) At the end of refresh of all reports, you can use logic app/power automate to send an email notification
https://www.mssqltips.com/sqlservertip/7414/refresh-power-bi-dataset-integrate-power-automate/