What's new in Power Query in Power BI, Fabric and Excel?

on YouTube ↗54m

" summary

Power Query online surfaces in Power BI Desktop and soon Excel delivering diagram view, schema/script view, query plans and step-folding indicators; Excel adds nested data types and lets Python read connection-only queries and render a seaborn chart inside a cell; Fabric Dataflows Gen2 imports .pqt templates, supports file upload, co-pilot generates M (add steps, create queries, explain logic), loads to Lakehouse/Warehouse/SQL/ADX with append/replace/dynamic-schema options, staging uses a background Warehouse, and paginated reports can now use Power Query with parameter passing.

AI-written summary · about

" chapters (7)

1. 0:00Power Query updates
2. 1:35Power Query in Power BI Desktop
3. 7:14Power Query in Excel
4. 19:53Power Query in Excel Online
5. 23:47Data Flows Gen 2
6. 40:39Power Query in Paginated Reports
7. 49:00Q&A

" related talks

• 01h 13mDiscover, Acquire, and Transform Your Data with Power QueryMiguel Llopis · PASS Business Analytics Conference 2015
• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 01h 04mBest Practices for Collecting and Analyzing Data with Power Query and ExcelChris Webb · PASS Business Analytics Conference 2015
• 48mGo With The (data)FlowMaria Gabriel · SQLBits 2023
• 46mMicrosoft Fabric Synapse data warehouse Q&AOlivia Shea, Joanna Podgoetsky, Priya Sathy, Shawndell Elfring, Bogdan Crivat, Steve Howard, Faisal Mohamood · Microsoft Build 2023
• 54mExtending PowerPivot into a Scalable Component for Enterprise BIAvi Perez · PASS Business Analytics Conference 2013
• 50mFabric: What's new and what's nextAmir Netz, Arun Ulagaratchagan, Flavien Daussy, Adam Penhaul · Microsoft Build 2024
• 45mRebooting your SME Data Analysis StrategyMark Hayes · SQLBits 2020