Forum Discussion
Customize report according to user
Hello.
I have a basic report structure that I want to share with the users of my company. However, the report deals with data from the whole company, and I don't want people to have access to the sales data from their coworkers.
To avoid that, I would like to show everyone the same report, but filtering the data of the report according to the user who is accessing it.
What would be the best way to do that in Power BI?
Thanks in advance
Hi auron9 ,
You can use Row Level Security (RLS) Technique to achieve the result .
Please follow these link to implement RLS for your Power BI Report :
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
https://www.youtube.com/watch?v=u-vTMUZwilE
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
2 Replies
Hi auron9 ,
You can use Row Level Security (RLS) Technique to achieve the result .
Please follow these link to implement RLS for your Power BI Report :
https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
https://www.youtube.com/watch?v=u-vTMUZwilE
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C@pratyashasamal
Thanks for the quick answer!
I just have another question that precedes the creation of the roles, because I haven't created the users for my company yet, and want to make sure I deal with that correctly.
How should I create these users in order for them to be accessible from my Power BI? Do I have to create them inside an organization where I'm the admin?
