Forum Discussion
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:
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
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 !
Please post screen shot of your flow in Power Automate. It seems somehow the email frequency is modified.Regards,
Hasham
The flow is nothing special (no attachments or something else):
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:
Also no special things so far.
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,
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: [email protected]
Thanks
