Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Row Level Security

Hey! I had created Row Level Security in the power BI Desktop as : [Email] = username().   I had done this so that RLS is applied dynamically. I am a little confues with what the following sentence...
Need Help
Show and Tell
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    It is necessary to add any members under Dataset -> Security -> Add members column in the Power BI Service when you use "usename( )" or "userprincipalname( )" in power bi desktop.

    It is a little misunderstanding for you about "usename( )" or "userprincipalname( )" in RLS.

    I would suggest reading the blog, which just gives some explanations around when and how deploying it to the Power BI Service.

    http://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

     

    Best Regards

    Maggie

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous

It is necessary to add any members under Dataset -> Security -> Add members column in the Power BI Service when you use "usename( )" or "userprincipalname( )" in power bi desktop.

It is a little misunderstanding for you about "usename( )" or "userprincipalname( )" in RLS.

I would suggest reading the blog, which just gives some explanations around when and how deploying it to the Power BI Service.

http://radacad.com/dynamic-row-level-security-with-power-bi-made-simple

 

Best Regards

Maggie