Copying workspaces creates new datasets

[Zabeer]

Hello,

I have a dataset A which is used in 3 reports on a particular workspace. I copied the reports from this workspace using an external app (Power BI helper). However, this has resulted in creation of three individual datasets A1, A2, A3 for each of the reports. Is there an easy way (apart from recreating the reports using the Dataset A and publishing them again to the workspace) to ensure that dataset A is used and not the individual datasets?

Thanks.

[v-kkf-msft · Accepted solution]

Hi @Zabeer ,

If your reports are in a new workspace, and you have Build permission for the dataset A. Then you can make a copy of them and save them to different workspaces.

First, make sure your tenant has enabled the option"Use datasets across workspaces". 

Then copy the report to another workspace. This will not generate another dataset A.

Copy reports from other workspaces -- Microsoft 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @Zabeer ,

once you have published the data set you can create a second report and connect to the already published data set:

From then on you should only copy the second file. That way the connection always stays to the published data set.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic