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.

Lightbot's avatar
Lightbot
New Member
9 years ago

AnonymousI've only applied myself at the moment, but I shouldn't need that for a single field table that just shows USERNAME() from a calculated column or measure should I?

 

Thanks

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Lightbot,

What error message do you get in Power BI Service? Based on my test, when I create column using the formula in the blog, I get error message” CUSTOMDATA, USERNAME and USERPRINCIPALNAME functions are not supported in calculated tables/columns. These functions may only be used in Measures or in the AllowedRowsExpression”.

Security_Category = NOT(ISBLANK(LOOKUPVALUE(security_mapping[CATEGORY],security_mapping[CATEGORY],[Category],security_mapping[EMAIL],USERNAME())))

In addition, you apply yourself as RLS role member in Power BI Service, right? Please note that by default you have Admin rights to the model when you create the Power BI Desktop file and upload it, you will be able to see everything in the reports, thus to check if the RLS works as expected, please share your dashboard with other user who has limited access to data in reports, for more details, please review this similar blog.

 

Thanks,
Lydia Zhang

  • Lightbot's avatar
    Lightbot
    New Member
    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.