Forum Discussion
LinhNguyen
Helper II
6 years agoRole 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
Community Support
6 years agohi 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