Forum Discussion

Lightbot's avatar
Lightbot
New Member
9 years ago
Solved

USERNAME() and USERNAMEPRINCIPAL() not working on published report.

Hi,   I'm trying to implement user based filtering using RLS as described here:   https://community.powerbi.com/t5/Community-Blog/Different-approach-to-Dynamic-Row-Level-Security/ba-p/80108   B...
  • Lightbot's avatar
    Lightbot
    9 years ago

    Hi Anonymous,

     

    When I signed into the report yesterday the measures were working fine, so my initial problem is solved.

     

    Thanks for the info about the admin rights, I had wondered that but the confirmation has helped testing.

     

    I've managed to solve my security problem using a simpler RLS:

     

    [Category] = LOOKUPVALUE(security_mapping[Category], security_mapping[Email], USERNAME())

     

    Thanks for the help.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Lightbot Have you applied users to the roles in the Service? Go to the dataset -> Security and you need to apply different users or groups to the roles you've created.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

So...  are you saying for the filter on User() I have to add ALL users to the Row-Level Security?  Wow!  that is over 250 people!   Or, just those with advanced rights in the workspace?