Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Not able to get RLS to work on a second table

Hoping someone can help me with row level security here. I have a budget table and a transactions table which are linked together in the data model. My budget table rls is working and is applied to o...
Need Help
  • shebr's avatar
    shebr
    8 years ago

    Ah, I see, so you should in best practise use the same security filter as in certain cases one will counter act the other. If you disable that security filter does this one work? What are you filtering on the other one?

  • Anonymous's avatar
    Anonymous
    8 years ago

    Thanks for your assistance on this one. I deleted the relationship between the two tables and the RLS works well independently. You touched on what I believe to be the issue though, that is the RLS should use the same security filter or one will counter the other. In addition, if the tables do not need to be related then independent RLS is possible. 

     

    Thanks again!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Are you sure [ORGN_CODE]  has the value of 10100 ?

 

Another point to note is - If you apply the RLS in the master table, the crossfiltering will pass to the transaction table but the vice versa wont happen.

 

Thanks

Raj

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Yes, [ORGN_CODE] has the value of 10100. I have also noted your filter point as well. Thanks for the reply overall however, I still am unable to get this working. As a troubleshooting measure I've tried filtering by other columns on the transaction table and no luck with anything I seem to try there. 

 

Any other ideas?

 

Thanks, 

 

aday

  • shebr's avatar
    shebr
    Resolver III
    8 years ago

    Hi Anonymous

     

    There are a few things that may need to be set here, can you share the pbix file by any chance? Appreciate it may be sensitive data.

     

    Thanks

     

    shebr

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I'm sorry I cannot share the file (sensitivity) however, what settings are you speaking of?

      • shebr's avatar
        shebr
        Resolver III
        8 years ago

        Hi Anonymous

         

        A couple of things you could check to begin with, the data type of the value you are filtering. Ensure this is a text value accross the board.

         

        Also, add the column to the page filter of your report and test that it works by just selecting and applying that filter.

         

        Can you share the code you have used in your role filter please?

         

        Thanks

         

        shebr