Everything About ___
Live briefing

Everything about Power Query

ETL tool developed by Microsoft

Power Query is an ETL tool created by Microsoft for data extraction, loading and transformation, and is used to retrieve data from sources, process it, and load them into one or more target systems. Power Query is available in several variations within the Microsoft Power Platform, and is used for business intelligence on fully or partially self-service platforms. It is found in software such as Excel, Power BI, Analysis Services, Dataverse, Power Apps, Azure Data Factory, SSIS, Dynamics 365, and in cloud services such as Microsoft Dataflows, including Power BI Dataflow used with the online Power BI Service or the somewhat more generic version of Microsoft Dataflow used with Power Automate. Wikipedia →

🧭 Start here: a 6-step reading path

  1. Read the overview: Power QueryA 5-minute orientation
  2. Skim a recent paper: A Lightweight Architecture for Query-by-Example Keyword Spotting on Low-Power IoT DevicesInfluential work since 2022
  3. Pick up a classic book: The Definitive Guide to DAXThe most-reprinted book on the subject
  4. Read the landmark paper: Recursive query processing: the power of logicCited 95 times
  5. Go sideways: Microsoft Power BIA closely related topic
  6. Go sideways: Power PivotA closely related topic

📖 Definitions

No dictionary entry for this exact phrase.

🗂️ The subject at a glance

  1. History
  2. M formula language

🏆 Landmark papers (most cited)

🆕 Influential since 2022

📚 Books worth reading

Ranked by number of editions on Open Library, a rough measure of how lasting a book is.

🔗 Related topics