Single Dashboard pulling from Multiple Workspaces

Used for anything related to the new Power BI Desktop and Service tools
samgray85
Posts: 7
Joined: Mon Jun 22, 2015 6:37 pm

Single Dashboard pulling from Multiple Workspaces

Postby samgray85 » Tue Apr 14, 2020 11:06 pm

Hi

I have several workspaces created as a by-product of creating MS Teams for different business units.

I want to use the workspaces to create PBi Dashboards and Reports

And then I want to cherry pick reports/tiles from individual workspaces into a dashboard in a separate workspace

Pic below illustrates - can it be done? Should it be done? Is there a another way to think about this?

[img]https://ibb.co/YDZQRk4[/img]

https://ibb.co/YDZQRk4

MattAllington
Posts: 1093
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Single Dashboard pulling from Multiple Workspaces

Postby MattAllington » Wed Apr 15, 2020 8:13 pm

Yes and no. I need to update my blog article about this, but I have been too busy to get to it. In short

Create a master report and publish to a workspace
The create a new power BI report that connects to the dataset in the first workspace. This is a thin workbook with no data of its own - it inherits the data from the first workspace
Publish the new workbook to a new workspace
Repeat as required
Once you have thin workbooks in one workspace, you can pin tiles into a single dashboard.

Hope that helps.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

samgray85
Posts: 7
Joined: Mon Jun 22, 2015 6:37 pm

Re: Single Dashboard pulling from Multiple Workspaces

Postby samgray85 » Wed Apr 15, 2020 11:34 pm

Brilliant

Hit a snag though at step 3

When I try to publish the new workbook to a new workspace, it only offers the original (source) workspace

MattAllington
Posts: 1093
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Single Dashboard pulling from Multiple Workspaces

Postby MattAllington » Thu Apr 16, 2020 5:36 pm

Do you have write access to an existing new workspace? You need the new workspace to exist, and you need to have write access to it.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

samgray85
Posts: 7
Joined: Mon Jun 22, 2015 6:37 pm

Re: Single Dashboard pulling from Multiple Workspaces

Postby samgray85 » Thu Apr 16, 2020 6:04 pm

EDIT - could this be a new experience workspace vs classic workspace issue?
https://docs.microsoft.com/en-us/power- ... e-datasets


Yep - I created both workspaces through MS Teams

- When I connect to data source on my C:\ all those MS Teams workspaces are available as publishable locations

- When I try to connect to the PBi Dataset within one of the MS Teams (call it Team A) the publish dialogue box only offers Team A

MattAllington
Posts: 1093
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Single Dashboard pulling from Multiple Workspaces

Postby MattAllington » Sat Apr 18, 2020 8:06 am

It definitely could be that. You can only republish into a different workspace if both are the new type of workspaces. That is what the “new” shared datasets is/does
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training


Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 0 guests