How to combine data set from two workspace

Question

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.&nbsp;

amitchandak · Answer

Uzi2019 , refer if these can help
https://community.powerbi.com/t5/Desktop/Combine-multiple-workspace-into-another-workspace/td-p/1035516
https://community.powerbi.com/t5/Power-Query/Combining-data-sets-in-Power-BI-workspace/td-p/54283

uzi2019 · Answer

amitchandak&nbsp;, 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?

anonymous · Answer

Hi&nbsp;Uzi2019&nbsp;,&nbsp;Check if this helps.&nbsp;https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-discover-across-workspaces&nbsp;Regards,Harsh Nathani

amitchandak · Answer

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
&nbsp;

anonymous · Answer

HI&nbsp;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.&nbsp;&nbsp;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

Forum Discussion

How to combine data set from two workspace

5 Replies

Related content

Data Combining Problem

Combining Column Data

Underlying Error Privacy...combining of data

Combine Usage Metrics Across Workspaces?

Tables combine