Forum Discussion

Zakaria_1980's avatar
Zakaria_1980
Post Patron
5 years ago
Solved

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  
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Zakaria_1980 

    In addition to 

    Build a User Table as below.

    [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. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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