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.
Opis
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.
| Typ | Product |
|---|---|
| Znane także jako | Microsoft Power Query, M language |
| Dokumentacja | learn.microsoft.com/power-query |
| Licencja | wliczony w Microsoft 365 |
Sesje na ten temat (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
Developed by
- Microsoft · Organization
Is a
- Microsoft tool · Category
- Analytics and BI tool · Category
Part of
- Power Platform · Platform
Related to
- Power BI · Product
- Microsoft Excel · Product
- Microsoft Fabric · Platform
- DAX · Concept
- Power BI Desktop · Product
- Python in Excel · Product
Covered by
- Microsoft Certified: Power BI Data Analyst Associate (PL-300) · Certification
- Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) · Certification
Community wiki
Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.
Eksperci i firmy w tym temacie
Nikt jeszcze nie wskazał tego tematu. Dodaj go do swojego profilu.