Generate a new dataflow from Power Query queries in an existing Excel file

  • Article

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Power Platform product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Admins, makers, or analysts, automatically This feature is released. Sep 21, 2020 -

Feature details

You can create Power Query templates from your queries in Excel workbooks that can be used to create new Microsoft Power Platform dataflows from the same queries to seamlessly transition from manually refreshed datasets to cloud powered dataflows that keep your data updated.

Power Query templates can easily be shared with other people, making it easier to leverage existing queries from other authors.

Create Power Query templates from the File menu in Power Query in Excel

Set your Power Query template properties

Create new Microsoft Power Platform dataflows by importing Power Query templates

See also

Generate a new dataflow from Power Query queries in an existing Excel file (docs)