Power BI services - multiple reports as a data source

[Tormod]

We've developed a model of Self-Service principles where different organisations uses Query Editor to anonymize the data and then publish .pbix files to the Power BI services and publishing those reports on the web for anyone to interact with.

Due to the success of this approach we now need to gather that data and present it across organisations.

Is this possible within the Power BI framework in one way or the other?

(The Power BI services connector doesn't work as it can only connect to one report)

One of the web-reports: Norwegian Myocardial Infarction Register - Interactive results (sorry about the Norwegian text)

[v-yuezhe-msft]

@Tormod,

It seems that you want to combine reports of different datasets in a single dataset, right? If that is the case, you would need to connect to these different data sources in a Power BI Desktop file and re-create the report.

Regards,
Lydia

[Tormod]

---

wrote:

@Tormod,

It seems that you want to combine reports of different datasets in a single dataset, right? If that is the case, you would need to connect to these different data sources in a Power BI Desktop file and re-create the report.

---

I was afraid that was the case.

Since we're using the pbix-files as a the only data source this isn't possible. We don't have a data-source to connect to.

I was hoping that it was possible to publish the data from powerbi.com to a cloud service and then combine the different datasets into one single report using Power BI Desktop. 

[v-yuezhe-msft · Accepted solution]

@Tormod,

It is not possible to combine different datasets into one report as you describe. Consider the following workarounds.

1. Pin reports of different datasets to a single dashboard, then share the dashboard to users.
2. If you share reports to users in same organization, then publish app in Power BI Service.

Regards,
Lydia