Forum Discussion
Multiple Similar Dashboards - Replicate Changes
Hi ShafiqRuslan,
I think you should do it like this.
1. Get data from data source and create a report For site A and publish it to Workspace 1.
2. Refilter the data in the reprot that we created just now for site B and publish it to Workspace 2.
3. Create two dashaboards seperatly in Workspace 1 and 2.
Regeards,
Frank
Hi ShafiqRuslan
1. Get data from data source and create a report For site A and publish it to Workspace 1. Here we named the report for site A.
2. Save and copy the pbix and renamed the copy one to site B, open it and edit it (filter). Then publish it to the Workspace 1.
3. Then you can use the two reports site A and site B to create dashboard as you need.
Please notice here we needn't publish reports to different workspace.
Regards,
Frank
That's a great solution. However, does this mean that I have to filter out the data from each workspaces to reflect what's on that particular site?
Hi ShafiqRuslan,
You can filter the data what you want in the report, not the data source.
Regards,
Frank
So this is what I've done,
- Publish the master dashboard in two workspaces (master dashboard does not filter out any data)
- Filter out the data within the two separate workspaces - Workspace 1 = Site A & Workspace 2 = Site B
- Make a change in the master dashboard and republish in Workspace 1 & 2
- View Workspaces 1 & 2
The changes will be reflected on Workspace 1 & 2, but the problem is that the data in both Workspaces show not only Site A and Site B, but shows the data for all.
Is that right, or am I doing something wrong?
Hi ShafiqRuslan,
I think you should do it like this.
1. Get data from data source and create a report For site A and publish it to Workspace 1.
2. Refilter the data in the reprot that we created just now for site B and publish it to Workspace 2.
3. Create two dashaboards seperatly in Workspace 1 and 2.
Regeards,
Frank
Actually, I should've been clearer in my terminology.
I wasn;t aware of the differences between reports and dashboards.
What I'm trying to achieve is multiple reports, not multiple dashboards. That means your solution is not applicable to my problem right?
Is there any other ways of achieving this?