Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Advocate III
Advocate III

How to accomplish scheduling rls protected emails



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.

Community Support
Community Support

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,



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

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?

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.

Advocate III
Advocate III

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. 

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors