Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
DuncanYeah
Helper II
Helper II

Server Error Report

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

1 ACCEPTED SOLUTION
v-jianpeng-msft
Community Support
Community Support

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.

vjianpengmsft_0-1736904813153.png

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:

Step-by-Step: How to Trigger an Email Alert when a Specific Windows Service Starts or Stops on Windo...

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.

vjianpengmsft_1-1736904949200.png

vjianpengmsft_2-1736904969911.png

vjianpengmsft_3-1736905029666.png

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.

View solution in original post

6 REPLIES 6
v-jianpeng-msft
Community Support
Community Support

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

v-jianpeng-msft
Community Support
Community Support

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

v-jianpeng-msft
Community Support
Community Support

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.

vjianpengmsft_0-1736904813153.png

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:

Step-by-Step: How to Trigger an Email Alert when a Specific Windows Service Starts or Stops on Windo...

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.

vjianpengmsft_1-1736904949200.png

vjianpengmsft_2-1736904969911.png

vjianpengmsft_3-1736905029666.png

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.