Forum Discussion

rickferreiran's avatar
1 year ago
Solved

drill through for only specific users (page level security)

Hello
I have a table
user   user_email
1          [email protected]
2        [email protected]


I have a table in my report like this, that when I click in number I will go to another page using drill through.


Is it possibel only show the second page for the user that are the first table, I mean only the user that are on this table can do the drill through?

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi rickferreiran ,

    1. No, behaviors like Drill-through can't be set to be on or off for certain users. This is not support at this time, and please submit the idea. Welcome to Microsoft Fabric Ideas
    2. If users in the first table can see the data related to them after drilling through, the other users can only see the empty table/visual after drilling through, you can do this with a combination of row-level security, Slicer & navigation buttons. Please refer to: How To Implement Page-Level Security In Power BI | phData

    Best regards,

    Lucy Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • no.  Page Level Security DOES NOT EXIST.  Try not to waste your time.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi rickferreiran ,

    1. No, behaviors like Drill-through can't be set to be on or off for certain users. This is not support at this time, and please submit the idea. Welcome to Microsoft Fabric Ideas
    2. If users in the first table can see the data related to them after drilling through, the other users can only see the empty table/visual after drilling through, you can do this with a combination of row-level security, Slicer & navigation buttons. Please refer to: How To Implement Page-Level Security In Power BI | phData

    Best regards,

    Lucy Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.