Templates module in the get data experience

The Templates module lets you browse reusable starting points for your Power Query work. Use it when an available template matches your scenario and can save you from building the initial query logic yourself. Templates aren't limited to dataflows.

Use the search box to find a template, and then select the template that matches your scenario. The templates available depend on the product and experience you're using.

Screenshot of the Templates module showing a search box and example template cards.

The screenshot shows an earlier version of the Templates module with sales-related examples. Those examples don't represent the full scope of templates.

Choose a template that fits your task

Search for the scenario you want to start from, then review the available template's name and description before selecting it. A template designed for one business task might not fit a different source or output.

Follow the configuration steps offered by the selected template. Before relying on its output, review the resulting queries, source connections, filters, and any parameters it uses. A reusable starting point still needs to match your data and requirements.

Templates and Power Query template files

Browsing the Templates module and importing a saved Power Query template file aren't the same entry point. A Power Query template file uses the .pqt extension and provides a way to transfer query definitions between supported experiences.

For exporting or importing a .pqt file, including the supported entry points and connection requirements, go to Power Query template. Don't assume that every template in this module is a .pqt file or follows that file-import workflow.