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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
test124325
New Member

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 @test124325 ,

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.

test124325
New Member

Yes, Viewer Permission on the workspaces in general

Mkarwa-123
Resolver II
Resolver II

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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