Andrew Simmans on 19 Jan 2019 23:04:22
Can we have a mechanism to copy dataflows between Power BI / Office 365 Organisations (and also Workspaces). I develop Power BI for clients who are using a particular package and as such I have developed some "standard" Power Query Scripts. Currently I can copy these between Organisations or Workspaces by using Power BI Desktop and signing into the organisation I want to publish to. But you can't do this with dataflows. For others I am sure this requirement is also needed when moving things from a "Development" environment into Live. One simple approach could be to be able to export the JSON file (which one can do now) and then to be able to Import that into the new Organisation / Workspace.
- Comments (2)
RE: Copy dataflows between Organisations / Workspaces
You can currently export a dataflow's model.json which describes the dataflow including all of your power query functions and transforms and then import the model.json when creating a new dataflow in another workspace.
Alternatively you can use the Power BI REST API to export and import a model.json between workspaces. See Post Import In Group: https://docs.microsoft.com/en-us/rest/api/power-bi/imports/postimportingroup
RE: Copy dataflows between Organisations / Workspaces
I don't understand how this was not thought from the beginning....