Row level security in power bi service

[AgnieszkaRys]

I have applied dynamic @rls on data using userprincipalname(). On desktop 'view as' works perfectly fine. However in service there are some problems. For some users 'test view' in service works and for some who on desktop have correct view in service result is BLANK instead correct data.As a test I have created visual card which show userprincipal name and it shows correct user while testing on service. The problem with Blank data disappears when I change userpricipal info particular static email

[v-yueyunzh-msft · Accepted solution]

Hi, @AgnieszkaRys 

You can first check whether the corresponding viewer is given permission, and you need to ensure that there is no edit permission, otherwise the RLS will be invalidated.

Then you can also validate the role within the Power BI service to test :

For more information , you can refer to :

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

Dynamic Row Level Security (Dynamic RLS) - Microsoft Power BI Community

Best Regards,

Aniya Zhang

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

[ibarrau]

Hi AgniezkaRys. The only thing I think right now is to check if that those users have the role asigned in the security settings of the dataset at Power Bi Service. Be sure to check that.

I hope that helps,

[AgnieszkaRys]

• Hi ibarrau. They are assigned in the security settings of the dataset. So this is not the issue 😞