Forum Discussion
GraceTCL
5 years agoHelper II
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...
aj1973
5 years agoCommunity Champion
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.