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.

     

     

     

     

     

     

  • hemanth_423's avatar
    hemanth_423
    Frequent Visitor
    3 years ago

    Hi 

    Thank you for the response but i have a differnet scenario where i cant have relationship between fact and security table