Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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.
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.
thank you
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
You can add a visual level filter on the card visual for the current date or today.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |