Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Row-level security and Page-level access

Dear Experts,

I would like to ask you for your help with combining row-level security and Ppage-level access in one report.

 

I believe that for both I should use tables, but how can I combine both tables in one function in Manage roles with User = USERPRINCIPALNAME()?

Thank you in advance for your help!

Best regards

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    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

      Thank you Anonymous ,

      I would like to ask one more question related to this topic: I have a database with orders, where I have DataAccess defined in few separate columnd and I don't have all users that should have access with limited or not data (example below) 

      In Manage roles I could set separate filters for each user, ,how can I do this in case of managing this Access through table without filters for Dataset?

       

      Thanks in advance for your help!

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi Anonymous ,

        Please try to create a measure and add it to the visual's filter pane to restrict access data.

         

        Best regards,
        Community Support Team_Binbin Yu
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • if user have url of other page. they access through this solution right?