Row-Level Security Members Updating - Creative Solutions?

Within Power Query, I am dynamically pulling users emails & access to "unit" based on the latest access that they have in another system. Set this to my master list of units, Many (Security) to One (...