Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
I have a scenario which is like below.
I have created a dashboard in Power BI and it is live and working without any issue, Now user wants me to create an alert from this dashboard if certain parameter crosses threshold value. I have checked in Power BI blogs and it shows clearly that alerts can be send to the report owner alone. We can't change the recipients email address. Also in my case the recipients email address is also dynamic and can be taken from back-end tables.
For example,
My dashboard is about support ticket. So main filter in the dashboard is Ticket Number and each ticket belongs to a user and I can get the email id of the user and all the email id will be from the same domain. The requirement is if the SLA days of the ticket is crossed, the ticket owner should get the alert saying that the SLA is crossed for a particular incident.
So is there a way where I can handle this situation. I know Microsoft Flow can do this. But without that is there a way to handle this situation.
Thank You,
Rajesh S Hegde
Solved! Go to Solution.
Hi @Anonymous ,
Yes,only the owner can get the notifications from alert,for more actions,you need refer to power automate(power flow):
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Hi @Anonymous ,
Yes,only the owner can get the notifications from alert,for more actions,you need refer to power automate(power flow):
Best Regards,
Kelly
Did I answer your question? Mark my reply as a solution!
Hi @v-kelly-msft ,
I tried to use Power Automate and could able to generate the email notification for the threshold value. But There also, I have to hardcode the email address. Is there a way where I can get the email id from Power BI dataset within the Power Automate? If so please let me know that will solve my problem.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |