Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
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.
Yes, Viewer Permission on the workspaces in general
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
88 | |
83 | |
64 | |
49 |
User | Count |
---|---|
126 | |
110 | |
87 | |
70 | |
66 |