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 bot...
Data Protection
Need Help
  • 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.

Anonymous's avatar
Anonymous
Not applicable
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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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
    3 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you Anonymous ,

      Could you please guide me with this measure?

      And does it mean that I need to add filter to every visual in the report?

      Thanks in advance for your help,

      Best regards

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Anonymous ,

        Sorry, this question is off-topic from the previous topic. To make the post more relevant, please consider marking the replies that help you, and creating a new case for the new question, as this will better help other users with similar questions and allow more people to participate.

         

        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.