How to separate dataflow into test and production environment

[madpimenta013]

I have a dashboard in which it is fed by a dataflows, however, this dashboard is seen by the company's management, and is updated every day. I wanted to find some way for me to make changes to the dataflow in a test environment, so that if any maintenance I do does not work, this is not reflected in the final dashboard and continues to update the data normally. Does anyone know a way for me to do this?

[nandukrishnavs]

@madpimenta013 :

You can export Dataflow as Json file and Import this Json file into your Test workspace. Then you can make changes on Test workspace.

[madpimenta013]

I have a few questions about this:

- Is it possible for me to import a JSON file to create an entire dataflow from that file?

- Suppose I could import an entire dataflow via a JSON file. When I export the JSON file from the test environment and import it into the production environment, I'll lose all my relationships between the tables, right?

[nandukrishnavs · Accepted solution]

@madpimenta013 once you import JSON file in test environment, all tables will be available there. To move the changes to Prod environment, you could configure deployment pipeline.

But, it requires premium capacity. If you don't have premium capacity, i think you can copy MQuery from advance editor of each table and replace corresponding tables in the prod workspace. Then everything should work. You can try this.