Forum Discussion
Report Sharing
Dears,
I have a power bi Dashbaord which is for 4 or more Markets. I want that for the same report, each Market will be visible by a list of users only. how can I do this ?
Br,
Zakaria
Hi Zakaria_1980
In addition to amitchandak 's reply. You may need to build a User Table and use dynamic RLS to achieve your goal.
I build a sample for you.
Data Table:
Build a User Table as below.
Manage Role in Modeling.
[Market] = CALCULATE ( MAX(Data[Market]), FILTER ( User, User[Account] = USERPRINCIPALNAME() && User[Market] = Data[Market] ) )Then publish this report to service and add roles in Security in Dateset.
For more details you may refer to aj1973's Blog.
Result is as below.
If I read the report as User A, I can only see the values for Market1 that I belong to.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Zakaria_1980 , You have use RLS - Row Level security for that
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-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rlsHi Zakaria_1980
you need to implement the RLS (Row Level Security) in power bi desktop
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
Hi Zakaria_1980
In addition to amitchandak 's reply. You may need to build a User Table and use dynamic RLS to achieve your goal.
I build a sample for you.
Data Table:
Build a User Table as below.
Manage Role in Modeling.
[Market] = CALCULATE ( MAX(Data[Market]), FILTER ( User, User[Account] = USERPRINCIPALNAME() && User[Market] = Data[Market] ) )Then publish this report to service and add roles in Security in Dateset.
For more details you may refer to aj1973's Blog.
Result is as below.
If I read the report as User A, I can only see the values for Market1 that I belong to.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Zakaria_1980
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou
