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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Dynamic RLS in single Datasets not working

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

3 REPLIES 3
Anonymous
Not applicable

Hi @Anonymous ,

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

vbinbinyumsft_0-1690253953554.png

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.

Anonymous
Not applicable

Yes, Viewer Permission on the workspaces in general

Mkarwa-123
Resolver II
Resolver II

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

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.