Forum Discussion
Rank changes when RLS is applied
Hi Team, I have 3 tables Accountid table (used for RLS) Dealer Master table Fact sales tables I am showing ranking of dealers based on their sales quantity. I also want to apply RLS in my...
Anonymous Thanks for the reply.
Yes, its difficult to bypass RLS.
I was thinking of an altenative but I am stuck with implementation. Not sure if this is doable.
I created 2 Dealer table, one name Dealer_Table_RLS which I have modeled wtih RLS table so that dealers will get filtered based on RLS and a Dealer_Table with Fact sales for calculating rank of all dealers
Calculate Ranking for whole set of dealer using Dealer_Table and then some how lookup this ranks to the filtered Dealers from Dealer_Table_RLS table.
Hi Senthil,
You can also compute the Ranking wihtin Power Query or Backend as this needs to be static.