Dynamic RLS using UPN based on multiple values

[Anonymous]

Dear forum,

I'm hoping you can get me kicked of again.

For a company dashboard I'm looking to give dynamice RLS using UPN based on multiple values.

I have 2 tables.

Table 1 - Containing a list of users and what they can see. 

a@x.com can see all information from Company A, limited to Work Location 1.How to read this table?

b@x.com can see all information of Company A

d@x.com can see all information of all companies and work locations but only the information of Functions X and Y.

etc.

Table 2 - List of positions in our company

What I want to achieve is that the visibility in the dashboard is limited to what they are entitled to see. This should result in the following:

How can this be set up in a dynamic way using UPN? If so, how?

Thanks in advance!

[amitchandak]

@Anonymous , The last table seems like one you can use in RLS.  You need to have the position ID (if that alone can work) else concatenate fields and have the key in this table and another table.

Split the email ids into rows in power query  into rows

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Then you can join this table based on position id or combined column with table toy want to secure 

In role add

[email id] = userprinicpalname()

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

[Anonymous]

Hello @amitchandak ,

Thanks for the quick response.

The last table is one I've made manually in excel for reference and good understanding. If I would be able to use this setup, how can this be achieved this table in PBI?

Many thanks in advance for your help.

Kind Regards.