power bi alert email

[arkiboys2]

hello,

the power bi report has several columns. one of these columns is error_message

this report is populated for each day.

sometimes the table error_message column is populated with a text and in the report I highlight this cell in red.

how can I set the alert so when this error_message column is populated then an email is sent?

do I hve to have a measure for this?

thank you

[Angith_Nair · Accepted solution]

Hi @arkiboys2 

Yes you can achieve this using measure.

Follow the below steps:

> You can use a measure to count rows where error_message is not blank. This measure will serve as a basis for the alert.

ErrorCount = COUNTAX(FILTER('YourTable', NOT(ISBLANK('YourTable'[error_message]))), 1)

This ErrorCount measure will return a count of rows where error_message is populated.

> Add a Card visualization in your report and use the ErrorCount measure.
> This card will display the count of error messages each day.

> Publish your report to the Power BI Service.
> In the service, go to your report, locate the card visualization with the ErrorCount measure, and click on the ellipsis (...) menu.
> Select Manage Alerts and set up a new alert:
> Set the alert to trigger when the ErrorCount is greater than 0.
> Customize the frequency and conditions of the alert (e.g., once a day or every time data refreshes).
> Enable email notifications for this alert, so you receive an email whenever the ErrorCount is greater than 0.

[arkiboys2]

thank you

[arkiboys2]

hi

thanks fo rthe suggestion.

there are also columns for _year and _month and _day

how can I check if there is an error_message populated for today?

thank you

[Angith_Nair]

You can add a visual level filter on the card visual for the current date or today.