Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dynamic RLS with USERPrincipalName

Dears, I am using a basic dax expression "[Short UserId] = USERNAME()" and USERPRINCIPALNAME(). This is the table I am using:           The relationship we have:   When publishi...
  • henriquesilveir's avatar
    henriquesilveir
    7 years ago

    Anonymous the print screen is from the PBI Service? 

     

    could you post the other? 

     

    i asked you to post print of PBI service , and PBI Desktop.

     

    Create a report page for each print... one inside the powerbi.com other into your envoirment PBI Desktop.

     

    example: sometimes, inside your PBI desktop, the username could return mydomain\henrique.silveira inside the PBI Service [email protected]

     

    because this i want these 2 prints... if it till correcly you need make some changes to it works fine...

     

    PS: When you have a edit permission into workspace, RLS doesn't apply for edit members... 

     

    take a look:  https://docs.microsoft.com/en-us/power-bi/service-admin-rls

     

     

    Using RLS with app workspaces in Power BI

    If you publish your Power BI Desktop report to an app workspace within the Power BI service, the roles will be applied to read-only members. You will need to indicate that members can only view Power BI content within the app workspace settings.

     

    Another question, have you Applied security filter in both directions?

     

     

  • Anonymous's avatar
    Anonymous
    7 years ago

    henriquesilveir Thanks,

    There it was. Test members had edit permissions within the Workspace.

    The rest points were already verified and checked and everything seemed to be ok.

     

    Working properly now after giving read-only membership.

    Thanks for your quick responses.

    Kind regards,