Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Power BI -when a data driven alert is triggered

Posted on 25 Nov 2024 16:54:57 by
I have an alert in Power BI. That works fine notifying me when a threshold for a card visual moves greater than 0.  I want this to send an email to a group whenever that alert is triggered (1x per day but I don't know what time as it is contingent on when the power bi dataset refreshes).  I am unable to configure the alert to send an email to a group so I had to go to power automate. 
 
In Power automate, I selected the 'when a data driver alert is triggered'.  I read the documentation on this flow and it is slightly outdated.  There is an option now "how often do you want to check for items".  This is not in the documentation and it adds confusion to the process.  I don't really want it to check since the trigger should be that the alert itself was triggered.  This happens 1x per day as is. 
 
If I set the "how often do I want it to check" to hourly, will it check every hour and see that the alert was triggered and continue sending emails?  I believe so. I do not want that. I just want it to send the email when the alert is triggered. 
 
Hope that makes sense. I think how this flow was setup was simple and straightforward. Now, it is confusing.  
 
  • Suggested answer
    SwatiSTW Profile Picture
    SwatiSTW 157 on 25 Nov 2024 at 17:23:57
    Power BI -when a data driven alert is triggered
    Use the "When a data-driven alert is triggered" trigger in Power Automate. Set the "How often do you want to check for items" to "Daily" or "Every 24 hours". Add the "Send an email (V2)" action and put the group email address in the "To" field. Save the flow and test it to confirm it only sends one email when the alert triggers.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,246

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,884

Leaderboard