Forum Discussion
Power BI Report Server: sending a notification when a scheduled refresh fails
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.
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
- d_gosbell3 years ago
Super User
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