Forum Discussion
Role level security based on excel input
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 [email protected] China, Japan
person B [email protected] US, UK, Mexico
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:
Regards,
Lin
1 Reply
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:
Regards,
Lin