Email alerts from power BI report

[SaritK]

Hello Power BI community! 

I`m trying to create a report that will be updated daily and send alerts.

I want to recive an email alerts from the Power BI report when I have some words or descriptions that repeats themself. 

Can I do it torugh Power BI?

thank you !

[AllisonKennedy]

@SaritK If you create a DAX measures that checks for those words/descriptions repeated, then pin to a DASHBOARD in Power BI, you can manage alerts on the dashboard. Use the 'Card' visual in Power BI dashboard to ensure you'll see the 'Manage Alerts' option in the dashboard tile. 

https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts 

If you provide sample tables/data and more info on what you're looking to be repeated we can help further with the DAX formula you'll need. 

[SaritK]

Thank you Allison!

I tried to create the search measure in DAX but seems like it does not recognize my columms' as I recieve this error:

Do you know what I should change?

[AllisonKennedy]

@SaritK You need to give it context to search the table - can you provide a screenshot of your model view (relationships) and also explain what you mean by repeated values? Are you looking for the word error in a specific column to be repeated or just for the word 'error' to show up at all? 

You may find it easier creating a calculated column first, then create a measure to count the results in that column that return a value. Set an alert on that number.

[SaritK]

Hi Allison, 

Thanks again for helping. 

I have an Excel report of support tickets. 

I want to search the word "error" in the Short description column and recieve alerts to my email when there is nore then 10 "error" words in the report, in the "Short description" column.

this is the Excel I loaded, it is 1 sheet so I dont have relationships there :

[AllisonKennedy · Accepted solution]

@SaritK 

You need to provide the table name for your [short description] column in the measure, and also give it a row context, try this as a measure:

Total Errors = 

COUNTROWS( FILTER( table, SEARCH("error", table[short description], 1, -1) <> -1) )

Then add that to a card visual and set an alert with threshold greater than 10. 

NOTE: Once this goes above 10, you'll get a single alert and won't trigger again until it:

A) drops below 10 and then back up above

OR 

B) you increase or reset the alert

[SaritK]

Thank you for all the help Allison!

My report works now 🙂