Publish reports using Azure Devops- latest files

Question

Hi All,&nbsp;I am trying to use powershell script to deploy Power BI reports using Azure Devops.All works well when I use copy and publish task.All my 100 reports&nbsp; when checked-in were deployed from&nbsp; the source repo folder to&nbsp;Power BI.trigger:&nbsp;&nbsp;&nbsp;&nbsp;-masterpool:&nbsp;&nbsp;vmImage:&nbsp;'windows-latest'steps:-&nbsp;task:&nbsp;CopyFiles@2&nbsp;&nbsp;inputs:&nbsp;&nbsp;&nbsp;&nbsp;SourceFolder:&nbsp;'$(Build.SourcesDirectory)/PowerBIreports'&nbsp;&nbsp;&nbsp;&nbsp;Contents:&nbsp;'**.pbix'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TargetFolder:&nbsp;'$(Agent.TempDirectory)/$(Build.BuildId)'-&nbsp;task:&nbsp;PublishBuildArtifacts@1&nbsp;&nbsp;inputs:&nbsp;&nbsp;&nbsp;&nbsp;PathtoPublish:&nbsp;'$(Build.ArtifactStagingDirectory)'&nbsp;&nbsp;&nbsp;&nbsp;ArtifactName:&nbsp;'PowerBIArtifact'&nbsp;&nbsp;&nbsp;&nbsp;publishLocation:&nbsp;'Container'However, now I want to deploy only incremental changes using same approach is that possible?&nbsp;Everytime all&nbsp; the reports get picked up , I tried using below, but I am new to Devops and Powershell and struggling to find the right way, basically get pbix files in latest commit and publish those artifacts only.&nbsp;amitchandak&nbsp;&nbsp;trigger:-masterpool:&nbsp;&nbsp;vmImage:&nbsp;'windows-latest'steps:-&nbsp;powershell:&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#get&nbsp;the&nbsp;changed&nbsp;template&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$a&nbsp;=&nbsp;git&nbsp;diff-tree&nbsp;--no-commit-id&nbsp;--name-only&nbsp;-r&nbsp;$(Build.SourceVersion)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#assign&nbsp;the&nbsp;filename&nbsp;to&nbsp;a&nbsp;variable&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;"##vso[task.setvariable&nbsp;variable=fileName]$a"&nbsp;-&nbsp;powershell:&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;"$env:fileName"&nbsp; &nbsp; &nbsp;-&nbsp;task:&nbsp;CopyFiles@2&nbsp;&nbsp;inputs:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SourceFolder:&nbsp;'$(filename)'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Contents:&nbsp;'**.pbix'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TargetFolder:&nbsp;'$(Build.ArtifactStagingDirectory)\$(Build.BuildNumber)\PowerBIReports'-&nbsp;task:&nbsp;PublishBuildArtifacts@1&nbsp;&nbsp;inputs:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PathtoPublish:&nbsp;'$(Build.ArtifactStagingDirectory)\$(Build.BuildNumber)\PowerBIReports'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ArtifactName:&nbsp;'PowerBIArtifact'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;publishLocation:&nbsp;'Container'

v-cazheng-msft · Answer

Hi&nbsp;smtiwari,
&nbsp;
Maybe you could consider this solution. Everytime you run the deployment scripts for some reports, you keep the deployment timestamp for them. During the next deployment, check the saved deployment info before the script starts the new deployment and only deploy reports that haven’t been deployed last time.
&nbsp;
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!
&nbsp;
Best Regards,
Community Support Team _ Caiyun

Forum Discussion

Publish reports using Azure Devops- latest files

1 Reply

Related content

Publish Report

Reports Published

Published Report

Publish reports to app

Publishing Reports Permission Errors