Forum Discussion

ptmuldoon's avatar
ptmuldoon
Resolver I
1 year ago

RLS not working with UPN?

I struggling to understand why what I think is a basic RLS role is not returning the correct user.   I've create a Gen2 Flow that imports a user table that includes their email address.   I've adde...
Need Help
ptmuldoon's avatar
ptmuldoon
Resolver I
1 year ago

Apologies for the delayed response (was away all weekend).

 

But I'm doing everything here in the Power BI Service and not in desktop.  To summary what I've done is.

 

1. I've created a test Workspace in the Power BI Service.

2. Created a Gen2 Dataflow that imports 1 excel (Users) table

3. Create a TestModel within my Workspace, and added the Users table to the model.

4. Created basic Power BI Report.

5. Created Role, and assigned the Role to a User Group that I know I am a part of

 

 

 

In the report, I've created 2 cards, 1 showing the UserName, and another showing the Email Address. and 1 other table visual of the data.

 

The report appears to be listing the first (alphabetical) of the username and email, and not the logged in user.   And I have confirmed the UPN I am logged in as is listed in the Users table.   My Email is actually 'User7" in this test setup.

 

 
 

 

 
 

 

  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    Super User
    1 year ago

    ptmuldoon RLS will not apply to the dataset owner or workspace members. You have to check the RLS by testing in the Power BI Desktop like below.

     

     

    For Service, you will have to test it with a user who has only read access to the dataset and viewer access to the workspace. Check the below documentation for more information on RLS

    https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security

     

    Did I answer your question ? Please mark my post as a solution.

     

    Thanks,

    Jai