How to copy dataset using PowerShell Script

Anonymous — Mon, 06 May 2019 12:41:44 GMT

Hi Team,

We are stuck in the below scenario, need to copy Report with Dataset from One workspace to Another.

We have tried below method but it works only if the Dataset already exists in Destination Workspace

1) Copy-PowerBIReport

Copy-PowerBIReport -Name "Report_Copy_5" -Id $source_report_id -WorkspaceId $source_WorkspaceId -TargetWorkspaceId $target_WorkspaceId -TargetDatasetId $targetDatasetId

2) Export & Import option in Power BI API

Export report in Group
1. groupId -> Workspace Id
2. reportId -> Report Id
Import-Get Import in Group
1. groupId -> Workspace Id
2. importId -> This Import Id is not clear from where we get

Note: First Export report is not working as don't know how to store the PBIX output, second Import option won't work without importId which don't know from where to pass.

3) Clone report In Group

groupId - > Workspace Id
reportId - > Report Id
Request Body
1. targetModelId-> Target dataset id which assumes like dataset id available in Destination Workspace
2. targetWorkspaceId -> Target Workspace id

Note: this clone report clone the report every time on the same Workspace

Requesting you to provide proper guidance on how to accomplish the task, please share the PowerShell code.

Thanks in advance,

Santosh Sawant

topic How to copy dataset using PowerShell Script in Developer

How to copy dataset using PowerShell Script