Power BI Dataflow – Create Dataflow from Export
There are times when you need to copy a dataflow from one workspace to another workspace. Power BI service provides a simple way to export the definition as a json file and then import.
Dataflow Series
This post is part of a series on dataflows.
- Create a dataflow
- Set up dataflow refresh
- Endorsement
- Diagram View
- Refresh History
- Create dataflow from Export json file
- Incremental Refresh
YouTube Version
Export dataflow as json file
In the workspace of the original workspace, click on the three dots next to the dataflow and select Export json. When the file is ready a message will appear in the top right.
Create dataflow from json file
In the destination workspace click on the New dropdown and select dataflow. From the options then displayed select Import Model. Select a your json file. Once the json file has imported a message will appear in the top right.
Although your dataflow has been created you are left on the dataflow creation page. You need to return to the workspace to see your new dataflow.
Check Credentials
The dataflow will not have refreshes setup as that is not part of the model. It is also recommended that you confirm that the credentials are correctly loaded. If you the dataflow is from another user or another tenancy you will need to re-login each credential.
To check the credentials you need to click on the three dots next to your new dataflow and select Settings. In settings, expand Data source credentials. If any of the credentials have a cross next to them click on Edit credentials to re-login.
Conclusion
Part of my work is to build dataflows to assist people fathom the depths of Microsoft Project data. The ability to export a dataflow means I have been able to transfer a solution between different teams across the company.
