copying report from one workspace to other workspace with dataset

[Shahzz77]

i am trying to copy my report along with the dataset from one workspace to other. when i copy the report the dataset will not get copied it will only get linked to the original workspace. Is there any way to copy the dataset as well .

[Shahzz77 · Accepted solution]

I found the best way to do it download the Power BI helper tool by rezacad . Its a user freindly tool which solves all the problems . Copying and downloading of whole worksapce is easier in one click.Kudos to Rezacad

[v-luwang-msft]

Hi @Shahzz77 ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

HI @Shahzz77 ，

The best way I think is to download the pbix filie ,then publish to another workspace.

refer:https://community.powerbi.com/t5/Service/save-a-copy-No-linked-dataset-show-in-target-workspace/m-p/... 

Best Regards

Lucien

[mussaenda]

Hi @Shahzz77 ,

Copying a report from one workspace to another workspace does not copy the dataset. Only the report.

If you really need to duplicate the report and the dataset to another workspace, my idea is to download the report and upload on your desired workspace. In that case, the dataset is also copied.

But sorry to ask, may I know why you want to duplicate a dataset on a different workspace instead of the report only?

Hope this helps.

[Shahzz77]

the reason behind this is giving acess to the workspace to other person. if 20 reports are lying in one workspace and thier respective dataset are in other workspaces then i have to give acess to all the workspaces which are related. its a tedious task.

in my case i have 50 workspace.

[Shahzz77]

No tom martens.

I want to copy the report from one workspace to another.

ex : i have 10 reports published in workspace 1. Now i want to keep a copy of reports in workspace 2. So what il do is ill copy and paste the report from workspace 1 to workspace 2. 

Here comes the problem now, after copying in workspace 2 only report gets copies not the dataset, the dataset will be linked to workspace 1. If i want to give the access to anyone i have to give the access of both the workspaces.

[TomMartens]

Hey @Shahzz77 ,

users that have been assigned a role in workspace 2 do not need a role assignment in workspace 1. They just read permission on the dataset in workspace 1. It's also necessary to understand that the dataset permission does not affect Row Level Security.

Maybe you find my answer in this thread helpful: Re: Editing Multiple Reports with same models - Microsoft Power BI Community

Basically, it's not considered a best practice to copy the same dataset to different datasets.

Hopefully, this helps to tackle your challenge.

Regards,

Tom

[TomMartens]

Hey @Shahzz77 ,

I'm wondering if you are looking for this: https://docs.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix

Hopefully, this is what you are looking for.

Regards,

Tom