Pipeline copy/move from Prod to development

[sevenhills]

Hi,

On the power bi service, we have dataflow, dataset, reports, paginated reports, files and more all in prod, and it is premium workspace from the beginning. Now, we enabled pipelines, don't ask me why now and not before (clue: DBA)!

I am seeing steps and aware on how to move from dev to test to prod using pipeline. 

Is there a way to move all from prod to dev?

Also, to keep this as a strategey to integrate back with the use of pipelines ?

TIA

-------------------------------------------------

Note: I can download each from prod and re-upload to dev by fixing all the guids. But want to see if there is a automatic or easier way. I have over 500 items. 

[lbendlin · Accepted solution]

you can back-port from Prod to ITG, and from ITG to DEV.  I don't think you can back-port from Prod to DEV directly.

[sqaar__]

@lbendlin i tried to do it as you describe and i received an error:

Test and development are empty, do you know what can be reason for that?

Thank you,

Patryk

[sqaar__]

Even tho, I did "Reversed deployment pipeline" to see if i could move all things to the next stage (from prod to dev, then remove the pipeline and move from dev to prod) and its exactly the same error, no matter if i try to move all of them, one by one, for reports, datamart, and datasets.

Patryk 

[bcdobbs]

See the note on backward deployment here...

https://docs.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-get-started

The option is only available if prior workspaces are empty.

[sevenhills]

Thank you, I read the link before and our dev workspace is not empty.

Like it got messy, because they opened both and we started doing in both prod and dev.

[bcdobbs · Accepted solution]

Don't know how many objects you're dealing with but would something like this work in order to maintain stuff in the production space...

1) Save out copies from existing dev/test spaces.

2) Publish everything that doesn't already exist in prod.

3) Wipe your dev and test spaces

4) Backfill to empty spaces from prod.

5) Publish "correct" dev versions into the dev workspace over the top.

I think that will at least protect guids for production.

[nazoelpazo]

Could you please elaborate on your suggestion here to backfill to empty prod spaces? In the Deployment pipeline I only see the ability to deploy forward not backward.

[bcdobbs]

You can only do it if dev and test workspaces are totally empty.

[sevenhills]

Thank you, we already suggested like we normally do DW backup and restore ... i.e., download and wipe out the whole dev space. Backfill from Prod and apply dev changes. It is complicated,  not only technical but also dba team vs bi.

There are about 800+ artifacts, roughly per 130 report collections ~ dataflow, dataset, paginated reports, interactive reports, dashboard.

Thank you.

[lbendlin · Accepted solution]

you can back-port from Prod to ITG, and from ITG to DEV.  I don't think you can back-port from Prod to DEV directly.

[sdemei]

Hi, 

Is there a build in option to "Back-port"?

[sevenhills]

Thank you. 

We are seeing only option as doing manually

- Download and upload each artifact, like fresh new reports from prod to dev

- For each one, fix the guid/links ...

- By doing this, we may lose our history of changes or refresh history.