Forum Discussion

KarenL7's avatar
KarenL7
Advocate V
4 months ago
Solved

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 ...
  • andrewsommer's avatar
    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