TopicsTopics
Topics

Topics

24 landing pages. Each collects every release, question, video and project for that topic.

DAX & Modeling

DAXMeasures, window functions, time intelligence and calculation groups.Semantic ModelsModel design, relationships and storage modes.Composite ModelsMixing import, DirectQuery and Direct Lake sources.Data ModelingStar schemas, granularity and modelling best practice.Performance TuningVertiPaq, DAX Studio, storage engine and query plans.

Power Query & M

Power Query (M)Shaping, folding and the M language across Excel & Power BI.

Power BI

Power BI ServiceWorkspaces, deployment pipelines, gateways and sharing.Row-Level SecurityStatic and dynamic RLS, roles and object-level security.Paginated ReportsPixel-perfect reporting with Report Builder and RDL.DataflowsReusable Power Query in the service and Fabric.Copilot in Power BINarrative, DAX and report generation with Copilot.Power BI REST APIAutomating the service: datasets, refresh and embedding.

Excel

PivotTablesClassic and data-model PivotTables, slicers and layouts.Power PivotThe in-Excel tabular model and relationships.Dynamic ArraysSpill ranges, FILTER, SORT, UNIQUE and array behaviour.LAMBDAReusable functions, REDUCE/SCAN and recursion in Excel.

Automation

VBA & MacrosAutomating Excel with VBA, events and the object model.Office ScriptsTypeScript automation for Excel on the web and Power Automate.Copilot in ExcelAI-assisted formulas, analysis and data cleanup in Excel.

Fabric

Direct LakeReading Delta/Parquet from OneLake at near-import speed.Microsoft FabricLakehouses, warehouses, pipelines and the OneLake platform.LakehouseDelta tables, shortcuts and the SQL analytics endpoint.

Visuals

Deneb & Custom VisualsVega/Vega-Lite in Power BI and the custom visual SDK.Conditional FormattingRules, icons and SVG measures for richer visuals.