Power BI Alerts and Power Automate

[Anonymous]

Hi there

I just wanted to confirm two PBI functionality items:

1. It appears that Power BI email data alerts are limited to Above and Below numbers?

PBI Alert Screenshot499×915 25.8 KB

1. Also, there doesn’t seem to be a way to programmatically set alerts for specific emails in a PBI table.
   In the example below, there are 10 email addresses (in practice there are 1000s). Jack should receive an email alert as his % in less than 100%, whereas Susan shouldn’t receive an email alert as her % is above 100%.

Untitled1721×299 8.77 KB

We don’t want to hard code these email addresses in Power Automate. We want PBI or Power Automate to go through the table containing emails and scores, and then email that user, dependant on if the alert is breached or not.

Is there a work around to hard coding the email address in Power Automate, and instead using a dynamic table/list of email addresses in PBI or even an external source?

Any assistance would be greatly appreciated !!

[GilbertQ]

Hi there

The only thing I could think of is either a report for each user or to use RLS, so that when the user logs in they would only see their data.

Once they can only see their data they could then create a data alert using the native Power BI Service functionality.

[Anonymous]

Thank you for the steer GilbertQ

The issue I have is how to get Power BI to loop through the various iterations of the one report.

Using the table example above the process would be:
Open the report and filter for Jack - check the alert - if breached send an email to Jack@email.com only
Open the report and filter for Gill - check the alert - if breached send an email to Gill@email.com only
Open the report and filter for Gill - check the alert - if breached send an email to Gill@email.com only
Etc, etc, etc x 10,000 times

So I would need Power BI to:
a) open the master PBI report, which includes 1000s of user names
b) filter and LOOP through each user name to check if alert is breached
c) if alert is breached, automatically send the associated user an email alert (the email address would be a field in the Power BI dashboard)
d) if the alert is not breached, then do nothing

Any further assistance would be much appreciated.