Role level security based on excel input

[LinhNguyen]

Hi,

I'm trying to apply role level security and we have an excel sheet with filter values that another department manage.

Is there any way I can apply role level security based on that excel sheet? 

for example, is there a way I can apply the country filter for each of these people automatically so that when their access changes in the excel sheet, I don't need to change it manually in pbix then upload it?

Name             email                   country

person A         A@abc.com        China, Japan

person B         B@abc.com        US, UK, Mexico

[v-lili6-msft · Accepted solution]

hi  @LinhNguyen 

Yes, you could.

You could import the excel sheet into power bi, then in the edit queries, split "country" column by "," .

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

Now selected "Name" and "email" columns and Unpivot other columns

Then create a relationship with fact table by Value column.

Now you could set RLS as below:

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

Regards,

Lin