Forum Discussion

Zabeer's avatar
Zabeer
Helper I
5 years ago
Solved

Copying workspaces creates new datasets

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.

Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    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.

2 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    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
     

     

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    5 years ago

    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.