Forum Discussion

hemanth_423's avatar
hemanth_423
Frequent Visitor
3 years ago
Solved

Help with Row level Security

I have a fact table with these information Manager Supervisor Agent Month-Year Commission Beth Tony ravi Saturday, January 1, 2022 252 Beth Tony bhushan Saturday, January 1, 2022...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the attached pbix file, and the below pictures.

     

    I suggest having a [Report to] column in Users table, like the attached pbix file.

    And then, try creating [Path CC] column in the same table.

     

    Path CC = 
PATH( User[Username], User[Report to] )

     

     

    Under "Manage roles" menu, 

    try wrting a formula like below.

     

    And then, you can try to test the result of RLS.

     

     

     

     

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

Please check the attached pbix file, and the below pictures.

 

I suggest having a [Report to] column in Users table, like the attached pbix file.

And then, try creating [Path CC] column in the same table.

 

Path CC = 
PATH( User[Username], User[Report to] )

 

 

Under "Manage roles" menu, 

try wrting a formula like below.

 

And then, you can try to test the result of RLS.

 

 

 

 

 

 

  • hemanth_423's avatar
    hemanth_423
    Frequent Visitor
    3 years ago

    Thanks a lot for the solution