Forum Discussion
Advocate IIIDashboards in Apps
I have been experimenting with dashboards in an App Workspace, but have not yet come up with a solution that meets my requirements. I was wondering if the collective knowledge of the forum could tell me whether it is possible, or am I banging my head against a brick wall. All of the users in the scenarios below are Power BI Pro users.
We have reports that use dynamic RLS to reduce the data that is visible to the user. This also reduces the options in slicers that they can select to filter the data. Out top level filter is Currency for the reports, and this is a single select slicer. So User A who is an admin creates a dashboard based on USD and sets this as the default dashboard, and publishes the App.
User B has RLS settings that only allow EUR reporting, so when they open the dashboard it is blank. Is there a way to make this top level single select slicer dynamic in the dashboard?
Alternatively User A can make a second EUR dashboard and republish the App. However User B will always get taken to the USD dashboard. Is there a way to set different default dashboards per user or group?
And finally User B would like to be able to make their own dashboard, as they are interested in different top level information. However when they try to pin a visual they get "Read-only content can't be pinned". How can a user create their own dashboards without being made an admin?
Thanks,
Chris
4 Replies
v-danhe-msftMicrosoft Employee
Hi Chris99 ,
In your situation, I suggest you use content pack to have a try:
https://docs.microsoft.com/en-us/power-bi/service-organizational-content-pack-create-and-publish
It could share different dashboard and different report to the users in your organization with RLS limitation and could allow the user to make a copy to create there own report.
Regards,
Daniel He
- Chris99
Hi v-danhe-msft,
Thanks for replying. I followed the link and it says
You can't create or install organizational content packs in the new workspace experiences preview. Now is a good time to upgrade your content packs to apps, if you haven't started yet. Learn more about the new workspace experience.So Organizational Content Packs are being replaced by App Workspaces, so this doesn't seem the way to go.
Chris
- DataZoe
Chris99 I can help out with this How can a user create their own dashboards without being made an admin? as I was wondering the same thing since yesterday and I figured it out this morning.
You can do this by first having the user copy the report ("..." --> "Save a copy") to their personal "My Workspace". From that copy, they can create their own personal dashboard in their 'My Workspace".
Pros:
1. the data is not copied, it is still linked to the app's data set. It will stay refreshed just like the original report.
2. they can also now modify the report to whatever they prefer in the browser.
3. their copy is sheilded from changes to the original report (which may break their dashboards)
Cons:
1. they have to copy the report, and if the original report changes, they would need to re-copy and re-build their dashboards
2. data model changes would impact them
It is not ideal, I think ideally it would be just pin charts from the app report to their personal dashboard, but this is a way to get them to do it now.
