Power Query

Product

Data connection and transformation engine with a visual editor and the M language, built into Excel, Power BI, Power Apps dataflows and Fabric.

Description

Power Query imports data from files, databases, web pages and online services, then cleans and reshapes it step by step. Every step is recorded, so the same transformation can be refreshed with one click when the source changes.

The same engine appears in several products: Get & Transform in Excel, the Power BI Desktop query editor, dataflows in Power Platform and Dataflows Gen2 in Microsoft Fabric.

Sessions on this topic (2)

• Excel for the 2020s with AI and modern tools · David Benaim · M365Con 2027
• Excel for the 2020s with AI and modern tools · David Benaim · M365Con 2027

Glossary

Related topics in brief

• Microsoft · Developed by · Organization
  Microsoft Corporation is a technology company that develops software and cloud services such as Microsoft 365, Azure and Dynamics 365.
• Microsoft tool · Is a · Category
  A software product or service developed by Microsoft.
• Analytics and BI tool · Is a · Category
  A tool for analysing data and building reports and dashboards.
• Power Platform · Part of · Platform
  Microsoft's low-code family consisting of Power Apps, Power Automate, Power BI, Power Pages and Copilot Studio. Together with Dataverse it lets business users build apps, automations, reports and agents.
• Power BI · Related to · Product
  Microsoft's business intelligence tool for turning data into interactive reports and dashboards. Semantic models define the data and measures, and reports can be shared in the Power BI service or embedded in other apps.
• Microsoft Excel · Related to · Product
  Spreadsheet application of Microsoft 365 for calculations, tables, charts and data analysis, with Power Query, PivotTables, dynamic arrays and Copilot.
• Microsoft Fabric · Related to · Platform
  An all-in-one analytics platform that combines data engineering, data warehousing, real-time analytics and Power BI on a shared storage layer called OneLake, billed through shared capacity.
• DAX · Related to · Concept
  Formula and query language for calculations in Power BI, Excel Power Pivot and Analysis Services semantic models.
• Power BI Desktop · Related to · Product
  Free Windows application for connecting to data, modelling it and authoring Power BI reports before publishing them to the Power BI service.
• Python in Excel · Related to · Product
  Excel feature that runs Python code directly in cells for analysis and visualisation, executed in the Microsoft cloud.
• Microsoft Certified: Power BI Data Analyst Associate (PL-300) · Covered by · Certification
  Associate certification for preparing, modeling and visualizing data and delivering reports with Power BI.
• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) · Covered by · Certification
  Associate certification for designing and deploying analytics solutions with Microsoft Fabric.

Experts and companies for this topic

Nobody has listed this topic yet. Add it to your profile.