Forum Discussion

msudulag's avatar
msudulag
Helper II
9 years ago
Solved

role level security dynamically for admin and other

                                  Hi All,   The above image is my data model,from this i want develope row level security,scanario is  If a user is Admin then he can see all...
Data Modeling
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    msudulag

     

    If a user has multiple roles include Admin, as I understand, he/she should can see all records when he/she sign in to Power BI Service with his/her email, right?

     

    Please try with following Table filter DAX expression

     

     

    Best Regards,
    Herbert

  • msudulag's avatar
    msudulag
    9 years ago

    Hi Herbert,

     

    Yes,same way i need to implement,

     

    I have implemented same way which you given DAX,but for me i am getting Error,

    In Filter first argument is table name,i given that one only.(GMP USER_APPLICATION_ROLE).

     

    Can you please verify the same.

  • msudulag's avatar
    msudulag
    9 years ago

    Hi Herbert,

     

    Thanks for Your Wonderfull efforts !!

     

    Finally i got the solution,You made me my day happy.

     

    Feeling very Exicted ,Thanks you Very Much.

     

    Regards

    Mallikarjunarao

     

     

msudulag's avatar
msudulag
Helper II
9 years ago

Hi Herbert,

 

Thanks for Your Help on this,

 

Same way i have implemnted in my scanario,i shared to one of my collegue he is not seeing anything,

he has two roles,one is Admin and Another one is Operator.

can you please help me on this.

 

a user have multiple roles like Admin,Operator,supervisor if role name is Admin he can see,other then Admin he needs to see only his records

 

Regards

Mallikarjun

 Here is my id i am not having Admin Role ,but i can see all the records.Can you please help me on this.

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

msudulag

 

If a user has multiple roles include Admin, as I understand, he/she should can see all records when he/she sign in to Power BI Service with his/her email, right?

 

Please try with following Table filter DAX expression

 

 

Best Regards,
Herbert

  • msudulag's avatar
    msudulag
    Helper II
    9 years ago

    Hi Herbert,

     

    Yes,same way i need to implement,

     

    I have implemented same way which you given DAX,but for me i am getting Error,

    In Filter first argument is table name,i given that one only.(GMP USER_APPLICATION_ROLE).

     

    Can you please verify the same.

  • msudulag's avatar
    msudulag
    Helper II
    9 years ago

    Hi Herbert,

     

    Thanks for Your Wonderfull efforts !!

     

    Finally i got the solution,You made me my day happy.

     

    Feeling very Exicted ,Thanks you Very Much.

     

    Regards

    Mallikarjunarao