Forum Discussion
etane
1 year agoHelper V
Multiple Dynamic RLS in One PBIX
Hello. I have a single PBIX file where I already have Dynamic RLS successfully implemented for Regional Managers. So, each Regional Manager can only see sales transactions in their own regions. ...
- 1 year ago
Thanks. One advantage, if it could be done this way that is, with two Dynamic RLS tables is I don't need to assign individual territories to each regional manager. It's an advantage in that when territory alignments change, I don't need to reassign territories in the Security table. And, in my salesforce dataset, the sales rep is the territory, and with high turnover, the Security table has to be constantly updated.
I could load territories to the fact table to overcome this. I know this quark might be unique to my dataset. But, your answer is very spot on otherwise.
lbendlin
1 year agoSuper User
You are using static RLS. Dynamic RLS has a single role and a reference table with permissions for each individual users.
Change to Dynamic RLS.