Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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, @Anonymous 

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

5 REPLIES 5
rvallejo
New Member

Hi all,

 

I tried the subscription to reports and dashboards some days ago and I can confirm that RLS is not applied for receivers of this mails. The question is that RLS in fact is being applied but to the user who creates the subscription.

 

Honestly, in my opinion I think this is a big gap from PowerBI Service. From my point of view Power BI Service should let the creator of subcriptions to decide if wants to apply the RLS to him or to the recipients of these mails. This will let administrators of workspaces in Power BI creating some kind of alerts system, which will increase the use of Power BI all along the company.

 

In other hand, you can promote this feature by voting this idea here:

https://ideas.powerbi.com/ideas/idea/?ideaid=712a09d7-c0c5-ea11-bf21-281878e6280d

 

v-robertq-msft
Community Support
Community Support

Hi, @Anonymous 

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.

Anonymous
Not applicable

Thank you ! it helps me. 

GilbertQ
Super User
Super User

Hi @Anonymous 

 

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

Anonymous
Not applicable

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.