topic Re: how do I duplicate a workspace in Developer

how do I duplicate a workspace

rajaachatterji — Mon, 16 Apr 2018 04:02:33 GMT

I need to duplicate a workspace which includes several Dashboards, Reports & Datasets. I need all of them from the Original one to a new workspace. How can I do it? Help required urgently. I can be contacted at: rajaa.chatterji@unifysolutions.net

Re: how do I duplicate a workspace

v-micsh-msft — Wed, 18 Apr 2018 05:00:31 GMT

Hi,

You may follow the blog below:

Duplicate workspaces using the Power BI REST APIs: a step by step tutorial

Regards,

Michael

Re: how do I duplicate a workspace

Anonymous — Mon, 21 May 2018 07:26:50 GMT

I am having trouble with using script for duplicating workspace. I would like to know, if anyone has managed to duplicate workspace over powershell script that is described here

Duplicate workspace with powershell

I am getting an error while duplicating dashboards. with reports I have no problems.

Error is shown below

Thanks

Borut

Re: how do I duplicate a workspace

Anonymous — Mon, 21 May 2018 19:01:10 GMT

Hi @Anonymous,

did you assign the required permissions to the native app?

for getting tiles you will need the Tile.Read.All and for the dashboards the Dashboard.Read.All.

Hope it helps,

Thanos

Re: how do I duplicate a workspace

Anonymous — Mon, 21 May 2018 20:09:02 GMT

Hi @Anonymous

I have followed the steps:

Install PowerShell and the Azure PowerShell cmdlets
Download the PowerShell script
Next, you will need a AAD client ID – you can get this in a few easy clicks from our app registration portal. For app type, select native app. For redirect URI, you can enter urn:ietf:wg:oauth:2.0:oob. Under API access, be sure to check all the boxes
Take the client ID you received in the step above and paste it into line 3 of the script
Run PowerShell as administrator and navigate to the directory where you downloaded the script
> ./copyWorkspace.ps1

From APP registration portal I have checked next

Dataset APIs

Read All Datasets

Read and Write All Datasets

Report and Dashboard APIs

Read All Dashboards

Read All Reports

Read and Write All Reports

Other APIs

Read All Groups

Create Content

Regards,

Borut

Re: how do I duplicate a workspace

Anonymous — Tue, 22 May 2018 05:04:24 GMT

Hi @Anonymous,

I think that it will need some debugging from your side. The problem seems to be arised from the request in this line of the script. You could probably add some debug messages in order to see what's going on.

I also quote some of the limitations of the script as mentioned in the step-by-step guide:

"Note that as-is, this script has some limitations.

Since we use the export and import PBIX APIs to copy datasets, we can only copy the datasets that were built in Power BI Desktop – i.e. streaming datasets, samples, etc., cannot be copied
You must have edit permissions on the source workspace, since edit permissions are required for export PBIX
This script won’t copy over refresh schedules, alerts, subscriptions, or workspace memberships – those will have to be manually recreated on the target workspace"

Additionally, this comment from Gregory Turner in the tutorial may be useful to you:

"Unfortunately, the piece that clones Tiles only works for pinned tiles from reports. Tiles with links do not get cloned right and the API seems to have no option for resetting properties".

Regards,

Thanos

Re: how do I duplicate a workspace

Anonymous — Tue, 22 May 2018 06:55:35 GMT

Hi @Anonymous

Thank you for comprehensive feedback. I have checked all the limitations that you have paste to the post. I have to say, that all my tiles are pinned from the report that exists. I also have tried to copy different workspaces. For example: small model, small report and dashboard, but without success.

Line you have marked in the code. I will check it, create some messages in order to get that line out printed and posted here.

Challenge 😉

Thanks

Borut