Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
I have the same problem, has anyone found a solution to this?
Without knowing the exact details of your problem, I would still suggest Row Level Security and a single App.
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.
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.
I'd be interested in knowing what solution you decide to go with for this. The reason we started using content packs was to allow the updating of a report that exists within multiple dashboards in one go.
Is there a way I can find out when content packs will be phased out and if there are any plans to incorporate this functionality into apps?
All of our reports have evolved to a point where they feature in multiple dashboards for different audiences - having one source file within the web app has reduced the admin required to maintain these.
I'd also be very keen to understand this, as im also facing the same problem
I have a similar situation. I created one big report for the entire division. This is viewed by the Division managment. Each department within the division has two or three tabs in the report. I want to create an App space for each department, and put their sections of the big report in the department's own app space. I would just publish the full report and update data in the Division level.
Just as a follow up, I have not heard anything to be able to answer your questions.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |