Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Pikachu-Power
Impactful Individual
Impactful Individual

twice email when alert is triggerd

Hello everyone,

 

In power bi service it is not possible to add emails when an alert is triggered. It is recommended to configure it via power automate. So i did.

 

I have a very simple flow that sends an email to five different colleagues when a power bi alert is triggered: 

 

Unbenannt.PNG

 

At the beginning it runs without problems. But after some days everyone gets the emails twice (same email with the same alert). I dont see any possibility to change that. 

 

In power bi service i said for the alerts just one alert in 24 hours. So i suppose it must be a mistake in power automate?

 

Any help is appriciated.

13 REPLIES 13
TrucNguyen90
Frequent Visitor

Hi Pikachu-Power,

I understand your scenario, you can refer my power automate flow below

TrucNguyen90_0-1750042706235.png

You need to create more steps to define condition if you want to send mail or not:

Step 1. When alert trigged: eg. Target Sales achieved 50% (you set on manage alerts on dashboard KPI)

TrucNguyen90_1-1750043031844.png

 

Step 2. Get a row: create an excel file on Onedrive, create a table data on excel to save current sales of KPI. This step helps you keep value KPI up-to-date and this place you can compare lastSales and currentSales to define your condition at the next step.

TrucNguyen90_2-1750043070038.png

 

Step 3. Compose: inputs the syntax below to get value in excel file you created at Step 2. This step helps you keep value lastSales

TrucNguyen90_3-1750043148937.png

Step 4. Compose: Inputs the Syntax below to get value CurrentSales. This step helps you keep value newest of KPI on dashboard (after you refresh Power BI)

TrucNguyen90_4-1750043309492.png

Step 5. Condition: you create conditions to seperate whether you want to send mail or not send mail. The condition is True when: 1) float(coalesce(outputs('CurrentSales'),0)) is greate than 0.5

2) float(coalesce(outputs('LastSale'),0)) is less or equal to 0.5

and if True: you send mail & update a row for excel online.

TrucNguyen90_5-1750043407469.png

 

Step 6: If false, you just only update a row. This step helps you save the newest of the value on KPI dashboard into the cell on Excel online.

outputs('CurrentSales')

 

These steps helps you config flow that send mail only one when trigger is alert, and then if alert is trigged one more time, the condition will be false and not send mail again, just only update a row for excel online.

But when KPI from 50% then down 40% and up 60%, mail notification will send again (that makes sense!)

If you have any question, you can send email: trucnguyendct84@gmail.com

 

Thanks

Pikachu-Power
Impactful Individual
Impactful Individual

The flow is nothing special (no attachments or something else):

 

Unbenannt.PNG

Hi guys,

I've just tested it but sometimes encountered the issue, sometimes it did not happen.

May I know if anyone got the issue resolved yet?

Hi @Pikachu-Power !

Ok, so this is a data driven flow. So once data event is occuered it will trigger the flow.

 

Did you use this flow in your Power BI Service in aother step as well ? Please share how you configure Alert steps in Power BI Service.

I created a card in power bi desktop and put it on dashboard in service. And adjusted the warning:

 

Unbenannt.PNG 

 

Also no special things so far.

Hi @Pikachu-Power !

Yeah, i didn't noticed anything strange in both configurations. Let's try to run the flow manually to see if it sends 2 emails as well. You can do this by cliking on the flow & execute run.

 

Regards,

Hasham

Hi,

Yes I tried it manually two times... I always get two e-mails at the same time 😐

Hi @Pikachu-Power !

May be raise a ticket with Power Automate team, it seems wierd to get same email twice when running a flow only once.

 

Regards,

Hasham

No ideas from the Power Automate Team. Maybe this Alert concept should be revised in Power BI Service. Send an Alert to more colleages with power automate is associated with many problems. 

HashamNiaz
Solution Sage
Solution Sage

Hi @Pikachu-Power !

 

Did the users receives same Alert email at the exact time meaning both email 1 & email 2 arrives at exact same time. Or they arrive at different time but each day they have similar time of arrival.

 

Regards,

Hasham

In Power Automate the execution time is the same (same alert flow was executed twice). But the emails arrived one minute apart.

HI @Pikachu-Power !

It might be a possiblity that, flow is triggering twice first from with in Power BI Service when alert is generated & then later on in the second step where you triggered email flow.

 

Regards,

Hasham

Hi @Pikachu-Power !

Please post screen shot of your flow in Power Automate. It seems somehow the email frequency is modified.

 

Regards,

Hasham

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.