Forum Discussion
Advocate IISelective report sharing within an organization
Hi everyone,
I'm working on a report within an organization.
This report is composed by four sections: each of them must be used by a specific target of people of this organization. Anyway, the dataset and the measures are the same for each section, so there is a unique report.
What are your suggestions regarding the sharing?
- If I create four different dashboards I should divide the master report into four different report, each one for a section (in order to deny to the users to access to other sections)
- I think that the same will be If I share with four different groups
- Could the right option be the content pack opportunity?
Thanks in advance,
Regards.
rode One centralized model to support many reports is absolutely the best way to go. The vast majority of my recomended solutions revolve around implementing a single/few tabular models for scaling out corporate reporting efforts. This also gives you the ability to use the Live Connection and removes the need to manage refresh schedules.
5 Replies
rode This sounds like a good use case for Row Level Security. Depending on the data source, and connection method, you would apply it in the Power BI Desktop or SSAS model.
This article explains dynamic row level security and could also be implemented in the Desktop alone.
rodeHi Anonymous and thank you for your reply.
I don't think that this is the right solution: I already use RLS, but it allows the users to see a piece of data. They cannot deny a user to see a specific piece of report (that's my need!).
Thanks,
Regards.
rode You are correct. I missed the key piece.
My thoughts are this, as there is no way to conditionally hide report pages themselves.
I would break out the reports into seperate pieces.
The main piece would be a single report that has all the common or shared parts for all the groups.
Then individual reports for each group
This would remove any potential duplication of report pages and be easier to manage down the road.
I wouldn't go the Content Pack route as those are eventually being deprecated. And I don't see how that resolves the issue. App workspaces / sharing apps would be the new way to share out content.