I am getting myslef familiarized with the Power BI RLS functionality. I need to develop a dynamic security set up for the model being built. The ask is to have the report be viewed by only the Managers or superiors who are part of the hierarchy.
My model has a shipment table with managers responsible. These managers have superiors as SVP’s and their superiors as Presidents. The shipments data will have the President’s ID’s, but in the future could have the SVP id as person responsible for the shipment to the customer.
President P1 - Can view all the data under his line of business
SVP1 - SHould view details of shipments of all managers under his Group
I have this hierarchy in a table -USers_hier.
Can RLS be applied if the user is not part of the shipments data?
Attaching my model here and looking for some advice.