Move queries from Dataflow Gen1 to Dataflow Gen2
Dataflow Gen2 is the new generation of dataflows. However, many existing dataflows were created over the years using the original version of dataflows (now called Dataflow Gen1 and listed as the Dataflow type in your workspace). This article describes how you can reuse your older Dataflow Gen1 dataflows by importing Dataflow Gen1 dataflows into Dataflow Gen2 using the export template feature. It also includes information on how to copy the Gen1 queries and paste them into a new Dataflow Gen2.
Use the export template feature
To use the export template feature:
From your Power BI or Data Factory workspace, select the ellipsis next to an existing Dataflow Gen1 and then select Edit.
In the Home tab of the Power Query editor, select Export template.
In Export template, enter the name you want to call this template in Name. Optionally, you can add a description for this template in Description.
Select OK to save the template. The template is saved in your default Downloads folder.
From your Data Factory workspace, select New, and then select Dataflow Gen2.
From the current view pane of the Power Query editor, select Import from a Power Query template.
In the Open dialog box, browse to your default Downloads folder and select the .pqt file you saved in the previous steps. The select Open.
The template is then imported to your Dataflow Gen2. You might be required to enter your credentials at this time. If so, select Configure connection and enter your credentials. Then select Connect.
Your Dataflow Gen1 is now imported to Dataflow Gen2.
Copy and paste existing Dataflow Gen1 queries
To copy existing Dataflow Gen1 queries:
From your Power BI or Data Factory workspace, select the ellipsis next to an existing Dataflow Gen1 and then select Edit.
In Power Query, select the query or queries you want to copy. If there are multiple queries or folders (called groups in Power Query) you want to copy, select Ctrl as you select the queries or folders you want to copy. Then either select Ctrl+C or right-click in the selection and select Copy.
Open an existing Dataflow Gen2, or create a new Dataflow Gen2 in Data Factory. To create a new dataflow, open an existing workflow and select New > Dataflow Gen2.
In the Power Query editor, select Get data > Blank query.
In the Blank query dialog box, select Next.
Select inside the Queries pane of the Power Query editor, and then select Ctrl+V to paste the query.
You might need to add your credentials before you can use the pasted queries. If a
Credentials are required to connect to the Web source.message appears, select Configure connection, and then enter your credentials.
Select Connect to connect to your data.
Once you connect to your data, right-click the initial blank query, and then select Delete to remove the empty query.
