Forum Discussion
LinhNguyen
6 years agoHelper II
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 ...
- 6 years ago
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
v-lili6-msft
6 years agoCommunity Support
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