Email Alert for a Scorecard

[aishak12]

All,

I want to create email alerts on a score card or Gauge. I will be using Power Query in Excel file to call PowerBI API. 

My question is in PowerBI can any formula work on the score card? 
I have two columns I am using to find the difference. I will be putting this on score card will this work? 

Also what if I have an alert for when the score card reaches 0. If it jumps to 0 and then 10 within minutes will it still alert me?  

[v-stephen-msft · Accepted solution]

Hi @aishak12 ,

Some limilations are as follows:

• Alerts aren't supported for card tiles with date/time measures.
• Alerts only work with numeric data types.
• Alerts only work on refreshed data. They don't work on static data.
• Since alerts are only sent if your data changes, you won't receive duplicate alerts for an unchanged value.
• Alerts only work on streaming datasets if you build a KPI, card, or gauge report visual and then pin that visual to the dashboard.
• You can create up to 250 alerts across all your models.

Alerts only work on refreshed data. When data refreshes, Power BI looks to see if an alert is set for that data. If the data has reached an alert threshold, Power BI triggers an alert.

About more details, you could refer to

Set data alerts in the Power BI service - Power BI | Microsoft Docs

Best Regards,

Stephen Tao

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