Email Alert in Power BI Dashboard

[hegdecisco86]

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

[v-kelly-msft · Accepted solution]

Hi  @hegdecisco86 ，

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!

[hegdecisco86]

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.