How to accomplish scheduling rls protected emails

[GoingIncognito]

Hi.

I need to send a multitude of emails once a month. Each of these emails should contain only information of the receiver - ergo need for rls.

Did I undestand correctly that sending the emails part can be done with premium license/report server? Does it also support rls?

Thank you.

[v-xicai]

Hi @GoingIncognito ,

You may set Row-Level Security (RLS), please see the link Power BI Desktop Dynamic security cheat sheet, which described the detailed steps. Maybe it doesn't work, there are some tips to let it work and test it efficiently. You can also refer to this case .

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GoingIncognito]

Thank you for the tips. I've one follow-up question, and I promise this will be the last one, can I iterate over a list of people maintaining rls? 

Scenario: myriad of people, each should get an email containing only their personal data. Can I do this dynamically, as in iterate over a list?

[GoingIncognito]

I still don't come forth understandably. I mean how to pick a value from a list dynamically. But how do I dynamically iterate over a list of people to send emails to? So that I send email to everyone on the list, but everyone gets a different email due to rls.

[GoingIncognito]

I might have been wrong - I really need a parameter not a rls?

What I want to accomplish is to send emails to a list of people. These emails should include only information of the receiver. As in, I've a list of people {a,b,c} and person a should only get information about person a.