twice email when alert is triggerd

[Pikachu-Power]

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: 

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.

[TrucNguyen90]

Hi Pikachu-Power,

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

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)

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.

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

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)

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.

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]

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

[shaynewill31]

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?

[HashamNiaz]

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.

[Pikachu-Power]

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

 

Also no special things so far.

[HashamNiaz]

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

[Pikachu-Power]

Hi,

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

[HashamNiaz]

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

[Pikachu-Power]

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]

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

[Pikachu-Power]

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

[HashamNiaz]

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

[HashamNiaz]

Hi @Pikachu-Power !

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

Regards,

Hasham