Forum Discussion
One Report in Multiple App Workspaces
I need to know the best solution for the following scenario:
Say I have two "apps" - one for Sales, one for HR.
Sales gets two reports - A and B
HR gets one report - A
To use report A in an App for both Sales and HR, do I have to publish the same report to each workspace, since the apps publish everything within an app workspace?
This is causing me a lot of difficulty in seeing the usefulness of the apps.
11 Replies
Do Sales and HR draw from the same data sources? Do Sales and HR see the same reports? How do you give them access? Are they shared dashboards?
One thought i had was either looking into Row Level Security, if they see different data rows.
If they get the same data, just different reports then you could create different dashboards and share dashboards with them.
Thanks for the quick response! Yes, I recognize I could use my existing app workspace which houses all my reports and simply use the "Share Dashboard" functionality, creating a dashboard for Sales, and one for HR.
I was more interested in how I could advance to using the new Apps functionality, but having the ability to use one report for two different Apps (because one app may have additional content that the other is not privy to).
From my playing with the Apps i'd noticed that an App contains the entire app workspace. That sadly doesn't help for what you want.
If both HR and Sales had the same reports, you could strip lines away but i'm guessing thats not what you want.
Alternatively, you could have separate PBIX files in seperate App Workspaces, but that means twice the refreshes and keeping to different PBIX files with different reports/dashboards.
My solution to this issue isn't a pretty one, but at least it works.
Create RLS security for the different departments, so they can use the same reports, yet see different data
Combine the various reports into different dashboards, one dashboard for each individual configuration (HR / Sales)
Then combine all these dashboards, reports en data in one app.
When HR logs in, it will be able to go to report B, but since RLS is setup, they will only see empty pages
Ideally, you want to be able to restrict the ability to see a dashboard within an app based on someones username/group membership, just as you are able to with RLS.
I have the same problem, has anyone found a solution to this?
