Forum Discussion

etane's avatar
etane
Helper V
1 year ago
Solved

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. ...
  • etane's avatar
    etane
    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.