Forum Discussion

GeorgeCH's avatar
GeorgeCH
New Member
3 years ago
Solved

How to manage multiple reports using the same data?

Hi there -   I maintain two reports for two different-but-related audiences. The reports use the same data - however, one of the reports contains sensitive information and is therefore accessible t...
Dataflow
  • sergej_og's avatar
    sergej_og
    3 years ago

    Hey GeorgeCH ,
    can you provide your end-result as an App to your audiences?
    In my opinion the best way to give users easy access and you can create different audiences for different permission groups or other focus. RLS would also work within the App.

    You will just need 2 reports (one for group 1, one for group 2).
    Then you can make an App and create different audiences within the App.

    We choose this way in our company to provide data.

    Maybe a suitable trial for you.

    Regards

cassidy's avatar
cassidy
Power Participant
3 years ago

Users shouldn't need Build permissions to see reports associated with a Report, they only need "Read".  I have a report where I do not want users to see the Dataset, only the Reports associated with it, so they are a Workspace (of the report) Viewer and a Dataset Permissions "Read".

 

 

That being said, you may have opportunity to use Row Level Security.  I've never had to and don't know much about it, but it's purpose is to limit what Data certain people see.

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls