cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SaritK
Microsoft
Microsoft

Email alerts from power BI report

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 !

1 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


Please @mention me in your reply if you want a response.

Check out my Tokyo 2020 report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

6 REPLIES 6
AllisonKennedy
Super User
Super User

@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. 


Please @mention me in your reply if you want a response.

Check out my Tokyo 2020 report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

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:

SaritK_0-1631455641436.png

Do you know what I should change?

 

 

@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.


Please @mention me in your reply if you want a response.

Check out my Tokyo 2020 report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

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 :

SaritK_0-1631531742287.png

 

@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


Please @mention me in your reply if you want a response.

Check out my Tokyo 2020 report with live stats - KUDOS much appreciated

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

Thank you for all the help Allison!

My report works now 🙂

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!