How to copy dataset using PowerShell Script

[Anonymous]

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

1. Export report in Group
   1. groupId -> Workspace Id
   2. reportId -> Report Id
2. 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

1. groupId - > Workspace Id
2. reportId - > Report Id
3. 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