Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 R...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    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.

     

    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's avatar
Anonymous
Not applicable
4 years ago

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