How to combine data set from two workspace

[Uzi2019]

Hi Experts,

I have an requirement to create a report based on two workspace's dataset. Can anyone help me out in this?

I tried but I can connect to only one workspace's dataset in desktop but I want to connect two workspace's dataset.

Pleas help me out.

[Anonymous]

HI @Uzi2019,

According to your description, I think you are testing to get data with power bi service connector on power bi desktop, right?
If this s a case, it is impossible to achieve your requirement.  Power bi desktop gets data from power bi service dataset with 'live connection' mode that only supports connecting one dataset per report.
Regards,

Xiaoxin Sheng

[harshnathani]

Hi @Uzi2019 ,

Check if this helps.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-discover-across-workspaces

Regards,

Harsh Nathani

[amitchandak]

@Uzi2019 , refer if these can help

https://community.powerbi.com/t5/Desktop/Combine-multiple-workspace-into-another-workspace/td-p/1035...

https://community.powerbi.com/t5/Power-Query/Combining-data-sets-in-Power-BI-workspace/td-p/54283

[Uzi2019]

@amitchandak , Thanks for your reply.

But I have also seen all these threads before posting my issue here. Could you please give me proper workaround for my requirment?

[amitchandak]

@Uzi2019 , see if these can help

https://radacad.com/power-bi-shared-datasets-what-is-it-how-does-it-work-and-why-should-you-care

https://www.youtube.com/watch?v=jtO4bIIy4uc