Forum Discussion

GraceTCL's avatar
GraceTCL
Helper II
5 years ago

Row level security

Hi I am attempting another formula to implement row level security by following steps at link: https://blog.pragmaticworks.com/dynamic-row-level-security-in-power-bi   Unfortunately, it doesnt wor...
Need Help
aj1973's avatar
aj1973
Community Champion
5 years ago

Hi GraceTCL 

In the Blog video, the guy used "IN" Capitol letters. Your formula is using "in".

Also before the LOOKUPVALUE in your formula you are missing to call the column from Access table and add "=" before LOOKUPVALUE.

 

Last code you don't need to call for the name of the table

 

Before you insert the formula into RLS, try to add it as a measure and see if it works, just like in the video.

 

 

 

GraceTCL's avatar
GraceTCL
Helper II
5 years ago

hi aj1973 I did but it still doesnt work even on real data. I am not sure if I need to filter directly on FoodMetrics table but am not sure how to do that.

  • aj1973's avatar
    aj1973
    Community Champion
    5 years ago

    GraceTCL 

    Not sure either what do you want to achieve! I tried to correct the formula that you have been using, eventhough I know that not every formula from one model can work on an other model, I mean the formula worked well for the Guy in the video, doesn't mean can work on your model.

     

    I recommend that you try creating measures one by one and see the result, then you can nest those measures into a one formula untill it works. Or use the filters in "Manage roles" untill you get what you need.

     

    I know that data in your model is sensitive or I would have asked for a Sample Pbix, but i am trying my best to help you.