cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBIlearning
New Member

RLS doesn't work with subscription

Hi everybody , 

 

I am facing an issue with Power BI service subscription feature. I subscribed a viewer user to the report he received a screen shut but with entire data without RLS applied. The RLS works fine in the workspce as he tested and he see only the data that the RLS allow to him but using the subscription  seems that the RLS doesn't work.

Just for information : the user has a PRO FREE trial account and the administrator a PRO account ( not free trial) .can this affect the RLS on subscription or it is just a limitation on tis feature ? 

 

Thank you for helping 

1 ACCEPTED SOLUTION
v-robertq-msft
Community Support
Community Support

Hi, @PowerBIlearning 

According to my research, when you use the Power BI report email subscriptions, if the dataset uses row-level security (RLS), you can create subscriptions for yourself and others. Those subscriptions will run using your security context.

v-robertq-msft_0-1620292166727.png

 

Therefore, the PRO FREE trial account won’t influence the RLS on subscription, it’s only because the RLS won’t work when the subscription owner has the edit access to this dataset.

 

More info about considerations for subscribing others

Row-level security (RLS) with Power BI

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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

View solution in original post

4 REPLIES 4
v-robertq-msft
Community Support
Community Support

Hi, @PowerBIlearning 

According to my research, when you use the Power BI report email subscriptions, if the dataset uses row-level security (RLS), you can create subscriptions for yourself and others. Those subscriptions will run using your security context.

v-robertq-msft_0-1620292166727.png

 

Therefore, the PRO FREE trial account won’t influence the RLS on subscription, it’s only because the RLS won’t work when the subscription owner has the edit access to this dataset.

 

More info about considerations for subscribing others

Row-level security (RLS) with Power BI

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

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

View solution in original post

Thank you ! it helps me. 

GilbertQ
Super User II
Super User II

Hi @PowerBIlearning 

 

When a subscription email is sent out for other users, it uses the permissions of the user who is sending out the subscription email.

 

What you need to do, is for this individual user to subscribe himself, this will then apply the RLS and let them view only the data they need to see.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thank you for helping. I try this and it works . but the issue here is that we can't tell End user to subscribe them selves. May using a Power BI app will resolve the issue. so that they can have access to the reports through power BI app. developers can modify in Power BI app workspace and then publish or update the application

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!