Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi everyone,
Are there are anyways that there will be an automated email sent to you when the report server is down or having error?
If yes, would you pls provide the document.
Thank You!
Best Regards,
Duncan
Solved! Go to Solution.
Hi, @DuncanYeah
For triggering mail alerts when Power BI Report Server is started and stopped, you can do so with the help of Windows scheduled tasks. Because Power BI Report server runs as a background service in your win server.
You need to use a PowerShell script to trigger this task. Happily, there are many such articles on the web, and you can refer to these two:
Trigger Email Alert When Specific Windows Service Starts Or Stops - SIOS SANless clusters
For Power BI Report Server to trigger a message when an error is encountered, you can set up a trigger in your SQL instance:
The Report server database records all user operations or scheduled flush executions. You can use T-SQL to write trigger conditions for alerts.
For setup steps, you can refer to this tutorial below.
Set up a SQL Server database alert (Windows) - SQL Server | Microsoft Learn
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @DuncanYeah
I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards
Jianpeng Li
Hi @v-jianpeng-msft ,
Thank you for your reply.
I still on the research stage and dont has a chance to test the solution.
I let you know if this works or not.
Thank you.
Best Regards,
Duncan
Hi, @DuncanYeah
I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.
Best Regards
Jianpeng Li
Hi, @DuncanYeah
For triggering mail alerts when Power BI Report Server is started and stopped, you can do so with the help of Windows scheduled tasks. Because Power BI Report server runs as a background service in your win server.
You need to use a PowerShell script to trigger this task. Happily, there are many such articles on the web, and you can refer to these two:
Trigger Email Alert When Specific Windows Service Starts Or Stops - SIOS SANless clusters
For Power BI Report Server to trigger a message when an error is encountered, you can set up a trigger in your SQL instance:
The Report server database records all user operations or scheduled flush executions. You can use T-SQL to write trigger conditions for alerts.
For setup steps, you can refer to this tutorial below.
Set up a SQL Server database alert (Windows) - SQL Server | Microsoft Learn
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-jianpeng-msft ,
Thx for your reply.
For the error part, is it only for error in data refresh, what if the server stopped unexpectedly by some errors.
Thank You.
Best Regards,
Duncan
Hi, @DuncanYeah
The service stops unexpectedly. You can refer to the first part to trigger an email notification when the Report Server encounters an error.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.