Duplicate reports are creating while deploying the report using Azure DevOps pipeline

Question

HI Team,&nbsp;Test Case 1:I am trying to deploy PBIX file (which is having only Report) into PowerBI service using Azure DevOps services using CI CD pipelines. While am trying to deploy it's duplicating the reports even am trying to provide as Overwrite argument using powershell and also it is not overwriting the existing one.&nbsp;&nbsp;New-PowerBIReport -Path $reportPath -Name $reportName -WorkspaceId $workspaceId -ConflictAction Overwrite&nbsp;

anonymous · Answer

Hi,&nbsp;Anonymous&nbsp;
I am glad to help you.
&nbsp;
First you need to make sure that all the parameters (e.g. $reportPath, $reportName, $workspaceId) in the PowerShell command are correct.
Then you can verify that the permissions are set correctly between the Azure DevOps service and the PowerBI service to ensure that there are permissions to override the report.
You can also try deploying using the PowerBI REST API, which may provide more control and options.
&nbsp;
And you can also check out this blog which helps you understand the CICD for Azure DevOps:
PowerBI - CICD using Azure DevOps - Microsoft Fabric Community
&nbsp;
&nbsp;
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.Best Regards,Fen Ling,If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;

anonymous · Answer

https://gallery.technet.microsoft.com/AzureDevOps-CICD-for-fefd58b8Provided link is not working, We have two workspaces 1 workspace for Dataset and 1 workspace for Report.&nbsp;When we are deploying the report using Devops pipelines the report is not being overwrite it is creating the new report id&nbsp;steps:#&nbsp;Step&nbsp;1:&nbsp;Copy&nbsp;PBIX&nbsp;File&nbsp;to&nbsp;Artifact&nbsp;Staging&nbsp;Directory-&nbsp;task:&nbsp;CopyFiles@2&nbsp;&nbsp;displayName:&nbsp;'Copy&nbsp;PBIX&nbsp;File'&nbsp;&nbsp;inputs:&nbsp;&nbsp;&nbsp;&nbsp;SourceFolder:&nbsp;'$(Build.SourcesDirectory)'&nbsp;&nbsp;&nbsp;&nbsp;Contents:&nbsp;'${{&nbsp;parameters.reportName&nbsp;}}.pbix'&nbsp;&nbsp;&nbsp;&nbsp;TargetFolder:&nbsp;'$(Build.ArtifactStagingDirectory)'&nbsp;&nbsp;&nbsp;&nbsp;OverWrite:&nbsp;true#&nbsp;Step&nbsp;2:&nbsp;Publish&nbsp;Build&nbsp;Artifacts&nbsp;(PBIX&nbsp;file)-&nbsp;task:&nbsp;PublishBuildArtifacts@1&nbsp;&nbsp;displayName:&nbsp;'Publish&nbsp;Build&nbsp;Artifacts'&nbsp;&nbsp;inputs:&nbsp;&nbsp;&nbsp;&nbsp;PathtoPublish:&nbsp;'$(Build.ArtifactStagingDirectory)'&nbsp;&nbsp;&nbsp;&nbsp;ArtifactName:&nbsp;'drop'&nbsp;&nbsp;&nbsp;&nbsp;publishLocation:&nbsp;'Container'-&nbsp;task:&nbsp;maikvandergaag.maikvandergaag-power-bi-actions.PowerBIActions.PowerBIActions@5&nbsp;&nbsp;displayName:&nbsp;'Report&nbsp;Deployment'&nbsp;&nbsp;inputs:&nbsp;&nbsp;&nbsp;&nbsp;PowerBIServiceEndpoint:&nbsp;'Power&nbsp;BI&nbsp;for&nbsp;CICD'&nbsp;&nbsp;&nbsp;&nbsp;WorkspaceName:&nbsp;${{&nbsp;parameters.ReportWorkspaceName&nbsp;}}&nbsp;&nbsp;&nbsp;&nbsp;PowerBIPath:&nbsp;'$(System.DefaultWorkingDirectory)/${{&nbsp;parameters.reportName&nbsp;}}.pbix'&nbsp;&nbsp;&nbsp;&nbsp;Overwrite:&nbsp;true&nbsp;&nbsp;&nbsp;&nbsp;Create:&nbsp;false#&nbsp;#&nbsp;Step&nbsp;3:&nbsp;Report&nbsp;Deployment&nbsp;using&nbsp;Azure&nbsp;CLI&nbsp;(Replace&nbsp;or&nbsp;Create&nbsp;Report)#&nbsp;-&nbsp;task:&nbsp;AzureCLI@2#&nbsp;&nbsp;&nbsp;displayName:&nbsp;'Report&nbsp;Deployment'#&nbsp;&nbsp;&nbsp;inputs:#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;azureSubscription:&nbsp;'Power&nbsp;Bi&nbsp;Service&nbsp;Principal'#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;scriptType:&nbsp;ps#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;scriptLocation:&nbsp;inlineScript#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;inlineScript:&nbsp;|#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Install-Module&nbsp;-Name&nbsp;MicrosoftPowerBIMgmt&nbsp;-Scope&nbsp;CurrentUser&nbsp;-Force&nbsp;-AllowClobber#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Import-Module&nbsp;MicrosoftPowerBIMgmt#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Set&nbsp;up&nbsp;Service&nbsp;Principal&nbsp;credentials#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$applicationId&nbsp;=&nbsp;"&lt;Client-id&gt;"#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$securePassword&nbsp;=&nbsp;"&lt;Secure-Password&gt;"&nbsp;|&nbsp;ConvertTo-SecureString&nbsp;-AsPlainText&nbsp;-Force#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$credential&nbsp;=&nbsp;New-Object&nbsp;-TypeName&nbsp;System.Management.Automation.PSCredential&nbsp;-ArgumentList&nbsp;$applicationId,&nbsp;$securePassword#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$tenantId&nbsp;=&nbsp;"&lt;Tenant-ID&gt;"#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Connect&nbsp;to&nbsp;Power&nbsp;BI&nbsp;Service&nbsp;using&nbsp;Service&nbsp;Principal#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Connect-PowerBIServiceAccount&nbsp;-ServicePrincipal&nbsp;-Credential&nbsp;$credential&nbsp;-TenantId&nbsp;$tenantId#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Define&nbsp;variables#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$workspaceName&nbsp;=&nbsp;"&lt;reportName&gt;"&nbsp;&nbsp;#&nbsp;Name&nbsp;of&nbsp;the&nbsp;workspace#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$workspaceId&nbsp;=&nbsp;(Get-PowerBIWorkspace&nbsp;-Name&nbsp;$workspaceName).Id&nbsp;&nbsp;#&nbsp;Dynamically&nbsp;retrieve&nbsp;workspace&nbsp;ID#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$reportPath&nbsp;=&nbsp;'$(System.DefaultWorkingDirectory)/${{&nbsp;parameters.reportName&nbsp;}}.pbix'&nbsp;&nbsp;#&nbsp;Path&nbsp;to&nbsp;the&nbsp;PBIX&nbsp;file#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$reportName&nbsp;=&nbsp;"CI-CD&nbsp;Test"&nbsp;&nbsp;#&nbsp;Name&nbsp;of&nbsp;the&nbsp;report&nbsp;in&nbsp;Power&nbsp;BI#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(-Not&nbsp;$workspaceId)&nbsp;{#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Write-Host&nbsp;"Workspace&nbsp;'$workspaceName'&nbsp;not&nbsp;found.&nbsp;Please&nbsp;check&nbsp;the&nbsp;workspace&nbsp;name."#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;exit#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(-Not&nbsp;(Test-Path&nbsp;$reportPath))&nbsp;{#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Write-Host&nbsp;"Report&nbsp;file&nbsp;not&nbsp;found&nbsp;at&nbsp;path&nbsp;'$reportPath'.&nbsp;Please&nbsp;check&nbsp;the&nbsp;file&nbsp;path."#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;exit#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;try&nbsp;{#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Get&nbsp;the&nbsp;existing&nbsp;report&nbsp;in&nbsp;the&nbsp;workspace#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$existingReport&nbsp;=&nbsp;Get-PowerBIReport&nbsp;-WorkspaceId&nbsp;$workspaceId&nbsp;|&nbsp;Where-Object&nbsp;{&nbsp;$_.Name&nbsp;-eq&nbsp;$reportName&nbsp;}#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;($existingReport)&nbsp;{#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Get&nbsp;the&nbsp;report&nbsp;ID&nbsp;of&nbsp;the&nbsp;existing&nbsp;report#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$reportId&nbsp;=&nbsp;$existingReport.Id#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Write-Host&nbsp;"Existing&nbsp;report&nbsp;found.&nbsp;Report&nbsp;ID:&nbsp;$reportId"#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Replace&nbsp;the&nbsp;report&nbsp;using&nbsp;Import-PowerBIReport&nbsp;with&nbsp;-ConflictAction&nbsp;Replace#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;New-PowerBIReport&nbsp;-Path&nbsp;$reportPath&nbsp;-WorkspaceId&nbsp;$workspaceId&nbsp;-ConflictAction&nbsp;Overwrite#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Write-Host&nbsp;"Report&nbsp;'$reportName'&nbsp;(ID:&nbsp;$reportId)&nbsp;successfully&nbsp;replaced&nbsp;in&nbsp;workspace&nbsp;'$workspaceId'."#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;else&nbsp;{#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Create&nbsp;a&nbsp;new&nbsp;report&nbsp;if&nbsp;it&nbsp;doesn't&nbsp;exist#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;New-PowerBIReport&nbsp;-Path&nbsp;$reportPath&nbsp;-WorkspaceId&nbsp;$workspaceId#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Write-Host&nbsp;"Report&nbsp;'$reportName'&nbsp;successfully&nbsp;created&nbsp;in&nbsp;workspace&nbsp;'$workspaceId'."#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;catch&nbsp;{#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Write-Host&nbsp;"An&nbsp;error&nbsp;occurred:&nbsp;$_"#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;addSpnToEnvironment:&nbsp;true#&nbsp;Step&nbsp;4:&nbsp;Dataset&nbsp;Deployment-&nbsp;task:&nbsp;PowerBIActions@5&nbsp;&nbsp;displayName:&nbsp;'Dataset&nbsp;Deployment'&nbsp;&nbsp;inputs:&nbsp;&nbsp;&nbsp;&nbsp;PowerBIServiceEndpoint:&nbsp;'$(powerBIServiceEndpoint)'&nbsp;&nbsp;&nbsp;&nbsp;WorkspaceName:&nbsp;${{&nbsp;parameters.DatasetWorkspaceName&nbsp;}}&nbsp;&nbsp;&nbsp;&nbsp;PowerBIPath:&nbsp;'$(System.DefaultWorkingDirectory)/${{&nbsp;parameters.reportName&nbsp;}}.pbix'#&nbsp;Step&nbsp;5:&nbsp;Dataset&nbsp;Rebinding&nbsp;(Rebind&nbsp;report&nbsp;to&nbsp;the&nbsp;dataset)-&nbsp;task:&nbsp;PowerBIActions@5&nbsp;&nbsp;displayName:&nbsp;'Dataset&nbsp;Update'&nbsp;&nbsp;inputs:&nbsp;&nbsp;&nbsp;&nbsp;PowerBIServiceEndpoint:&nbsp;'$(powerBIServiceEndpoint)'&nbsp;&nbsp;&nbsp;&nbsp;Action:&nbsp;'RebindReport'&nbsp;&nbsp;&nbsp;&nbsp;CrossWorkspaceRebinding:&nbsp;true&nbsp;&nbsp;&nbsp;&nbsp;WorkspaceName:&nbsp;${{&nbsp;parameters.DatasetWorkspaceName&nbsp;}}&nbsp;&nbsp;&nbsp;&nbsp;ReportWorkspaceName:&nbsp;${{&nbsp;parameters.ReportWorkspaceName&nbsp;}}&nbsp;&nbsp;&nbsp;&nbsp;DatasetName:&nbsp;${{&nbsp;parameters.reportName&nbsp;}}&nbsp;&nbsp;&nbsp;&nbsp;ReportName:&nbsp;${{&nbsp;parameters.reportName&nbsp;}}

Forum Discussion

Duplicate reports are creating while deploying the report using Azure DevOps pipeline

2 Replies

Related content

Working with copy job and creating duplicates

Duplicate ranking

Create table to remove duplicates

Creating Relationships with duplicative values

Table Merge creates duplicate records