Dynamic RLS in single Datasets not working

[test124325]

Hello all,

I have the following problem. I have created a report in Power BI Desktop that uses a Single Dataset (via Direct Query). I have set up a RLS in the single Dataset as a dynamic RLS using the UserPrincipleName. The RLS works when I enter a user in the "View As" dataset in PBI Desktop and enable the RLS. Unfortunately, when I publish it, it does not work in the report that accesses this dataset. Is this basically not working or am I missing something?

Thanks and best regards

[Anonymous]

Hi @test124325 ,

In the Power BI Service Portal , please add the user to the RLS role.

For more details, you can read related document: Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[test124325]

Yes, Viewer Permission on the workspaces in general

[Mkarwa-123]

@test124325 Did you set up user on service and provide permissions.