Forum Discussion
How do I restrict access through profiles?
Good morning, thank you in advance for taking the time and reading my post.
I'm using Power BI with multiple college colleagues and we need to create multiple profiles simulating a company's range of operations and in each of these ranges, restrict access depending on the profile. For example, the secretary will have access to "Human Talent" data, but will not be able to see any of the contents of the "Inventory" data.
I'd like to know if we can do this in Power BI.
Thanks a lot
Hi kleydert,
I think setting up dynamic RLS based on username should suitable for your requirement.
You need to do create a user mapping table with username and correspond keys that link to other tables to enable the effects:In addition, you can also configure the filter on your database with user account. Then you parameterized the pbix with user credentials to generate a personal report file based on the current user account.
Deep Dive into Query Parameters and Power BI Templates
Regards,
Xiaoxin Sheng
2 Replies
kleydert , you need use RLS - Row Level security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchiesHi kleydert,
I think setting up dynamic RLS based on username should suitable for your requirement.
You need to do create a user mapping table with username and correspond keys that link to other tables to enable the effects:In addition, you can also configure the filter on your database with user account. Then you parameterized the pbix with user credentials to generate a personal report file based on the current user account.
Deep Dive into Query Parameters and Power BI Templates
Regards,
Xiaoxin Sheng
