Report Sharing

[Zakaria_1980]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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. 

[aj1973]

Hi @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

[amitchandak]

@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...
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-rls