Using Automate and Service to send a message to a dynamic group of users?

[BSLATTER]

Hello,

Using Power BI Service, I have constructed a simple report that has the following data

Email	Numeric
email1@email.com	1
email2@email.com	1
email3@email.com	1
email4@email.com	0
email5@email.com	0
email6@email.com	0

There could be a lot of emails in the list, and the field value can toggle between 0 and 1 at every refresh.

I'd like the report to email to the users that have a "1". Like a subscription.

Is there a way to dynamically select these users? Normal subcription and data-driven alerting didn't seem to, and was hoping there may be a way to send a similar email as a subscription (screenshot that links to report) to users with Power Automate

[Tad17]

May be best too look into doing this with Azure Security Groups.

[v-joesh-msft · Accepted solution]

Hi @BSLATTER ,

After my research, I'm afraid it couldn't achieve in Power BI for now. For your requirement, you can come up with a new idea and add your comments there to make this feature coming sooner. 

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi there

Currently there is no way to do this within Power BI.

You could look at automating it possibly with Power Automate?