Forum Discussion
KarenL7
4 months agoAdvocate V
Copy Reports into Production Workspace
Hi Hopefully someone can help. I have been asked to consolidate Power BI Workspaces, which I have been doing without any issues using Powershell script to copy reports to a workspace - which is ...
- 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
andrewsommer
4 months agoSuper User
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