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.

                                  (or)

Do we have any option to move dataflows from one workspace to other workspace.

 

Appreciate your response.

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , Add dataflow 2 the file. Right Click on the name of table in power query and open advance editor.

     

    Copy the first few lines till the table name 

    Paste the same in the old table in the advance editor , if needed change the table name in the next step

     

    refer if needed

    Change Connection from One source type to another Source Type and use existing steps: https://youtu.be/nwYJgG2hmd0

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks for your response Amit, but is there any other way to do it directly in service.

  • 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.