Create a measure on a table in power bi to set alert set if there is a new record

[fabiopaturzo]

I created a report inot Power BI that shows a table of record errors
I want to enable the set alert feature on power BI that alerts me as soon as there is a new record in the table.
It asks me to create a measure ?

any suggestions?

[Anonymous]

Hi @fabiopaturzo ,

Power BI alerts are based on measures applied to visualisation tools such as dashboards, KPIs and cards, rather than directly to tables. The following is a brief action plan to help you set up alerts:

1. you need to create a measure that counts the number of records in a table.

Measure = COUNTROWS('Table')

2. Place the measure in the card visualisation.

3. Pin the visualisation icon to the dashboard.

4. Set an alert on the dashboard tile.

For more details on setting up alerts please refer to the following link:

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

Best Regards,

Ada Wang

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

[fabiopaturzo]

Hi Ada Wang,

this solution works only first time if  a new row is added  because then you have to updated the threshold