Power BI office groups

[Heather]

I have a feeling that you and I went the rounds of this type of question before, with another project (related to schools), so rather than pointing you to that post, I thought I’d point to another post currently in the forum:

Variation of generating a list of combinations within Power Query

Hi all I am attempting to implement row level security (to determine which users can access specific rows within a Power BI report) and I am required to create a sort of bridge table that contains the required combinations of User IDs and Group IDs. I have not had any joy achieving this within Power Query. Again The general logic is that all region managers (IDs highlighted yellow) should be able to access their own group as well as other groups within their region) but with a tw…