Power Query (M)
Shaping, folding and the M language across Excel & Power BI. Follow this topic to get only what's relevant — every release, community question, video and project, in one place.
Recent for Power Query (M)
August Power BI Desktop feature summary is live
New DAX window-function options, on-object formatting improvements and Copilot updates ship in the August build.
Fabric adds more Direct Lake surface area
Direct Lake now covers additional connectors and a smoother fallback path to DirectQuery.
Power Query: query-folding indicators improved
'View Native Query' now surfaces on more transformation steps.
Office Scripts: scheduled triggers via Power Automate
Run a script on a recurring schedule without opening the workbook.
Direct Lake model keeps falling back to DirectQuery
Community thread pins the cause to unsupported data types and SKU guardrails.
Best way to unpivot 60 monthly columns in Power Query?
Answer: select the id columns, right-click → Unpivot Other Columns; keep it foldable.
DAX Studio 3.x: faster query plans view
New build improves server-timings capture and export.
Power BI user groups — this month's meetups
Regional groups post agendas and recordings.