Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
You can export Dataflow as Json file and Import this Json file into your Test workspace. Then you can make changes on Test workspace.
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?
@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.