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.