Dynamic RLS with UserName() and Multiple Cost Centers and Cost Centers Nodes in hierarchy

[Haleem]

My sample files are here
https://1drv.ms/f/s!AtMKO3vGEsG5gSQODCatb86kNR48

In continuation of my previous post which was resolved 
Dynamic RLS with UserName() and Multiple Cost Centers and Cost Centers Nodes in hierarchy 

Now I would like to ruplicate SAP BW Access file to Power BI. Access File is today managed in Excel and being uploaded to BW in order to control access rights of our SAP BI Cost Reports.

I would like to use the same file and upload it to Power BI in order to manage the access rights of users automatically using the USERNAME() in Power BI cost reports, to avoid maintaining parellel two access files. 

Problems:

None of the below table contains UNIQUE field!!!!!!

1. Access file contains combination of USER, Cost Center and/or Nodes

2. Data tables contains only Cost Center column not nodes

3. But we have separate file which contains Cost Centers Per node.. so how to replaces nodes in Access file (in point 1) with the cost centers 

4. how to link Access file to the Data File and then apply USERNAME function on access file in order to limit the user to see cost center he/she is having access to. 

What I ideally want: 

1. Upload all the three files to Power BI

2. Replace Nodes in Access File with relevant Cost Centers and link Access file to the Data file

3. Use USERNAME function through RLS Roles in order to manage the access rights automatically. 

Below is the overview of each of Sample tables. 

1. Data Table

2. Access File

3. Nodes and Cost Centers

[mwegener]

Hi @Haleem ,

here my solution on your sample data.
I hope it helps.

PBIX

[mwegener]

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.