Power BI report server to send an alert email to end user when a exceeds beyond he Target

[Vandithak]

Urgent help required!!!

Is Power Bi Report Server will support Email and Text Notifications when the Data value exceeds beyond the Target value. If yes, can you please write a blog or upload a video to understand on this. Its like Setting Email and text  alerts to end users

Incase if its not supported what else is Possible to send an email alert to end user when the data values exceeds beyond the Target value

[Anonymous]

Hi, @Vandithak 

Power BI Report Server doesn't natively support email and SMS notifications when data values exceed target values. You can set up data alerts on dashboards in the Power BI service. These alerts can trigger email notifications when data exceeds a specified threshold. You can check the following link:

Tutorial for setting data alerts on Power BI service dashboards. - Power BI | Microsoft Learn

You can also use the Power Automate integration to create workflows that send email or SMS notifications based on changes to data in Power BI. You can learn more information from the following link:

Get started with Power Automate - Power Automate | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vandithak]

Thanks for the response Yongkang Hua. My requirement is to Use Power Bi Report Server only not required from Power BI Service/Cloud level.
In your response you mentioned to Use Power Automate to create a Alerts, but when i referred that It doesn't show Power BI Report Server Intergration.

I need help on how to Integrate Power AUtomate in Power BI Report Server to send an alerts and Email Notifications.?

[R1k91]

if you are using Power BI Report Server you've a SQL Server installation somewhere.
you can build yourown t-sql stored procedures to check values and send email using db mail feature. everything can be scheduled with SQL server agent. 

obviously with this approach you need to evaluate the metric outside of your power bi model.

maybe there's a way to run a DAX query against the shadow ssas tabular instance...

[Vandithak]

My requirement is use to only Power Bi report server. I think metrics (Preview) won't support in the Report server. 

[SamWiseOwl]

Hi @Vandithak 

Have you looked into using Power BI Metrics:
https://learn.microsoft.com/en-us/power-bi/create-reports/service-goals-power-automate

These can be set up to be connected to data and have goals.

Then use Power Automate to send an email when a goal is reached.

This could be a card displaying a target in Power BI that the metric reads.

[Vandithak]

Thanks Sam for the reponse. Will it be works in Power BI Report Server?

[SamWiseOwl]

You create Metrics in the browser and then can leave it:

Or you can then reference this metric in the report: