topic Re: Power BI Report Server: sending a notification when a scheduled refresh fails in Report Server

Power BI Report Server: sending a notification when a scheduled refresh fails

CorradoPag — Fri, 10 Feb 2023 14:43:02 GMT

Hi, is it possible to get notified when a report schedule failed in Power BI Report Server?

Re: Power BI Report Server: sending a notification when a scheduled refresh fails

d_gosbell — Fri, 10 Feb 2023 23:27:47 GMT

There is no built-in feature to do this. The failure information would be in the log files, so you could build a process to ingest those and notify you from there.

I think it's also technically possible to find that information in the database, but the schema is not documented and accessing the database directly like that is only supported for the ExecutionLog views. If you access the other tables /views you could deadlock with internal Report Server processes and affect the stability of your system. But you will probably find blog posts from people who have figured out approaches like this.

Re: Power BI Report Server: sending a notification when a scheduled refresh fails

CorradoPag — Wed, 15 Feb 2023 14:20:03 GMT

Hi d_gosbell, thanks for the reply.
Where are the log files?
What do you mean by "build a process"? Are you talking about a shell script or a process created with Power BI?
Thanks again

Re: Power BI Report Server: sending a notification when a scheduled refresh fails

Anonymous — Wed, 15 Feb 2023 14:44:00 GMT

This should be built-in but it's not.

Personnally I use the following query on the ReportServer database to get the failed refreshes and I'm using our monitoring system to throw an alert if it returns any rows.

WITH latest AS ( SELECT ItemPath, MAX(TimeStart) AS LatestTimeStart FROM dbo.ExecutionLog3 WHERE ItemAction = 'DataRefresh' GROUP BY ItemPath ), scheduled AS ( SELECT c.Path FROM dbo.Catalog c INNER JOIN dbo.ReportSchedule rs ON c.ItemID = rs.ReportID ) SELECT * FROM dbo.ExecutionLog3 log INNER JOIN latest ON latest.ItemPath = log.ItemPath AND latest.LatestTimeStart = log.TimeStart INNER JOIN scheduled ON latest.ItemPath = scheduled.Path WHERE latest.ItemPath <> 'Unknown' AND log.Status <> 'rsSuccess' AND log.TimeEnd > DATEADD(DAY, -1, GETDATE())

Re: Power BI Report Server: sending a notification when a scheduled refresh fails

R1k91 — Wed, 15 Feb 2023 14:50:03 GMT

d_gosbell 's idea is great. you should definetely follow his suggestion

logs by default are here: C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles

under installation folder.

Re: Power BI Report Server: sending a notification when a scheduled refresh fails

d_gosbell — Sat, 18 Feb 2023 01:17:21 GMT

Yes, something like a shell script or an SSIS package that would read the files which are normally stored at C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles as R1k91 mentioned earlier