Receive email for Refresh failure

Hi gemidriver,

The scheduled refresh history will be recorded in Power BI Report Server database hosted on SQL Server. Maybe you could configure an alert in SQL Server when the state of scheduled refresh is recorded as "Failure" which will send an email to specific recipients.

Reference: PBIRS scheduled refresh data refresh: Execution history
                  Query Details of given SSRS Report from ReportServer Database tables

                  Send an email from a trigger

                  Get an alert when a certain record changes in SQL Server

Best regards,

Yuliana Gu