Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dataflow change to dataset

Hi Everyone,   I have a requirement to change dataflow for dataset. Currently my dataset is pointing to dataflow A, I want to it to dataflow B since Dataflow is going to removed.                 ...
Need Help
Show and Tell
Tips and Tricks
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous 

 

You can refer to this video: Migrating Power BI Dataflow Across Workspaces | PawarBI.com - YouTube 

Export dataflow definitation into JSON file and import it into another dataflow. 

 

If your dataset is using a dataflow as its data source, it will specify the dataflow id and workspace id for connection. If you want it to point to another dataflow in another workspace, you need to provide new workspace id and dataflow id for it. 

 

One option is to modify the workspace id and dataflow id in Power BI Desktop and publish the report to Power BI Service again. This is shown in the above video.

 

If you are familar with Power BI REST APIs, you may try this API Datasets - Update Parameters In Group - REST API. I haven't tested it yet so I'm not sure whether it supports to change dataflow type data sources. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.