Forum Discussion
gemidriver
8 years agoHelper II
Receive email for Refresh failure
Is it possible to setup email alerts if a scheduled refresh fails?
gemidriver
8 years agoHelper II
ok so it isn't supported
is there something that can be used ?
we have some schedules failing to refresh, and it would be great to be able to be notified in some way
cheers
v-yulgu-msft
8 years agoMicrosoft Employee
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
Get an alert when a certain record changes in SQL Server
Best regards,
Yuliana Gu
- gemidriver8 years agoHelper II
Hi
Any ideas on tables/columns to monitor?