Forum Discussion
Copy Reports into Production Workspace
- 4 months ago
This is technically possible to do but it partially bypasses the pipeline model you’ve put in place.
When you use PowerShell (or the REST API) to copy reports into the Prod workspace:
- The reports will land successfully
- They will not be tracked as artifacts in the deployment pipeline
- Future pipeline deployments will not manage or overwrite those reports
- You risk drift between Dev/Test/Prod environments
In other words, you’re mixing two deployment paradigms:
- Pipeline-governed assets
- Manually injected assets
If this is a one-time consolidation and reports are static:
Do it, but treat it as an exception case with guardrails:
- Document that these reports are out-of-band from the pipeline
- Ensure:
- Dataset bindings are correct
- Permissions are revalidated
- Any shared datasets exist in Prod with matching schema
- Avoid future pipeline deployments that might:
- Overwrite workspace contents
- Create confusion about “source of truth”
Lookout for:
- Dataset binding mismatch; Same name ≠ same dataset ID
- Shared dataset dependencies; Reports may silently point back to non-prod datasets
- Endorsement & lineage loss; Certified/promoted status won’t carry cleanly
- App publishing; If you use Power BI Apps, you’ll need to republish after copying
Hi andrewsommer
Thank you for your reply.
That is very thorough. It is a great check and very helpful I had a feeling it was technically possible, but was unsure. I have used the script to copy between workspaces successfully but not with a pipeline before.
As this would be a one time migration of some old reports, we would not want the data to be refreshed once the report and dataset lands into the production workspace. THis was my biggest concern. You are correct this would be out of sync once it lands, but I will make this clear to the owners of the report before this takes place. I am not sure they would worry as these are reasonably old.
Again thank you for your help, and I will make this as the solution.
Karen