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...
Thanks for suggestion.
RLS (Filter data for that particular vendor) will be applied first on entire dataset and then Rank logic will get executed. Just giving a thought that creating any expression/logic to unhide rows would work ?
I am doing research on it. This Rank is always been complicated in PowerBi with the way of requirement i have.
If anyone finds solution please suggest and will greatly appreciate your help!
OK, if you go to the documentation, you'll find this:
Hence, your only option is to replicate a table or a set of tables. No other way, I'm afraid 😞
Here's the documentation: Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Docs