Subscription with Dynamic RLS

[Anonymous]

Hi experts,

i need your valueble suggestion on PowerBI subscription.

i've created one sample dynamic RLS and published into workspace. 

now whenever i checked test as role i can see RLS is working fine. but after published my PBIX file i created one subscription and i given 4-5 mails along with my mail.

now if i run subscription then generating hole data RLS is not working with subscription.

can you please help me on this issue, how we cam resolve this one ?

regards,

Tom

[amitchandak]

@Anonymous , You created RLS with userprincipalname or you simply created a role with the only filter?

In case the only filter-based RLS is created with roles. Make sure you assign email IDs to the role in the service.

make sure setting are correct as per this video : https://www.youtube.com/watch?v=MxU_FYSSnYU

[Anonymous]

hi @amitchandak ,

i have users table like EmpID, Emp Name, Emp Email

now i created dynamic rls like,

 Emp Email = usersprinciplename()

now after that i published into workspace and i've created one subscription and added 4 users after that getting same pdf.

So RLS concepts not working when we created Subscription.

we need more suggestion on this.!!!!

regards,

Naveen

[v-yingjl · Accepted solution]

Hi @Anonymous ,

For paginated and 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.

Please note that:

For members of a workspace with Admin / Member / Contributor roles, RLS does not take effect, regardless of how it is shared.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.