Forum Discussion
Helper IHow to separate dataflow into test and production environment
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.
Community Champion
You can export Dataflow as Json file and Import this Json file into your Test workspace. Then you can make changes on Test workspace.
Helper II 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
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.