Connect multiple power BI data sets in the same report

[Anonymous]

Hi, we have multiple Live Power BI reports and we would like to connect them to a single Power BI report.  Any ideas on how to do this?

[Anonymous · Accepted solution]

Hi,

By Connecting to a Report, I suppose you mean to Connect to Reports' Dataset. If that is the case, You will have to publish the First Report containing all Data in Import Mode. Then, you can connect the various reports to the Dataset of the First Report by Choosing Power BI Datasets under Get Data. Please make sure that the Account under which you have published the first report and the Account that you are using to Connect to the Published Dataset are the same.

Best Regards,
Vignesh M

If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂

[v-frfei-msft · Accepted solution]

Hi @Anonymous ，

Did you mean conneting to power bi dataset in power bi desktop? That is a kind of live connection, so we cannot connect multi datasets at the same time.

[Anonymous · Accepted solution]

Hi,

By Connecting to a Report, I suppose you mean to Connect to Reports' Dataset. If that is the case, You will have to publish the First Report containing all Data in Import Mode. Then, you can connect the various reports to the Dataset of the First Report by Choosing Power BI Datasets under Get Data. Please make sure that the Account under which you have published the first report and the Account that you are using to Connect to the Published Dataset are the same.

Best Regards,
Vignesh M

If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂