Send email based on threshold of Power BI visual card

[pbinoob_5]

Hi expert,

I want to ask help regarding sending an email using Power Automate based on threshold configured in Power BI service (Card Visual alert).

The threshold is if the Card Visual count is greather than 0, then it will trigger.
The rule is if dashboard has refreshed at 10am, it will check if today's value is decrease to 25%, then it will send an alert to user.
I already configure in Power Automate and yes the email received. But, thing is that is not what i expected. I understand in Power BI Alert only send data if data changes. But I have problems.
As below scenarios & result for once in 1 hour:
  1) If value remains (yesterday = 3 and today = 3) and click refresh (less than 1 hour): email not received.
  2) If value remains (yesterday = 3 and today = 3) and click refresh: email not received.
  3) if value changes (yesterday = 3 and today = 4) and click refresh: email received.
  4) if value changes and not click refresh: email not received
  5) if value changes and refresh (less than 1 hour): email not received.
  6) if value changes and not refresh (less than 1 hour): email not received.

The email only receives if yesterday and today's value changes.
Can anyone help me?

[v-sdhruv]

Hi @pbinoob_5 ,
I wanted to check if you had the opportunity to review the solution provided?
If the response/s has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Please feel free to contact us if you have any further questions.
Thank you

[v-sdhruv]

Hi @pbinoob_5 ,
I wanted to check if you had the opportunity to review the solution provided?
If the response/s has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Please feel free to contact us if you have any further questions.
Thank you

[v-sdhruv]

Hi @pbinoob_5 ,
I wanted to check if you had the opportunity to review the solution provided?
If the response/s has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Please feel free to contact us if you have any further questions.
Thank you

[v-csrikanth]

Hi @pbinoob_5   
Thank you for being part of the Microsoft Fabric Community.
In addition to @Akash_Varuna I add the few points as below.
By default, if the values haven't changed, Power Automate might not trigger the action, especially if the condition logic is set to only send an email if there's a difference between the two values.

You can follow the following approach-

Create alert : Condition- when value is greater than 0

Create a flow in power automate - Use (When data driven alert is triggered)  then send an email.

you can send email for both cases, even if values have changed or not changed by giving appropriate subject line.

Additionally, you can refer these resources for a better understanding.

https://www.youtube.com/watch?v=U32e_3vKx78&t=14s

https://www.cloudfronts.com/blog/power-bi/send-an-e-mail-to-any-audience-when-power-bi-data-alert-is...

Hope this helps !

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[Akash_Varuna]

Hi @pbinoob_5 I think if you do the logic inside Power Automate, this will work, as currently Power BI's alert system only triggers based on changes to the visual value It doesnt work for specific ThreshHold values so try the logic inside Power Automate

• Use Power Automate to retrieve and compare the current value with the previous day's value stored in a separate location.

• Implement the threshold logic (25% decrease) within Power Automate.

• Trigger the email based on the comparison result, ensuring alerts are sent even if the value remains unchanged but meets the threshold.

[pbinoob_5]

Hi @Akash_Varuna 

Thank u for your replied. I have tried put some condition in Power Automate (if Tile value figure is > 0, then send email), however I still didnt managed to get the email. Please help whats more I can adjust in Power Automate level.
Power Automate-Condition

[Akash_Varuna]

Hi @pbinoob_5 Could you Modify the condition to is greater than 1 Or your threshold value and see ... Ensure the title is correctly mapped and it is numeric type and the if conditions 

[pbinoob_5]

Hi @Akash_Varuna 
Sorry, its typo. it should be > 0. I still didnt get the email. Image below is selection other than "Tile Value" for your reference. What else can i do to solve this?