Describe it. Get the DAX.
Type a calculation in plain English and get back a real DAX measure — or a Power Query M step — with a full explanation. Free, no signup required — 5 a day, or go Pro for more.
Try the Formula BuilderFunctions covered in the reference docs
Stop reading examples. Try them.
Most Power BI references show you a formula and a result and leave it at that. On 39 function pages so far — DAX and Power Query M — you can edit the numbers yourself and watch the actual result recalculate, right on the page, no Excel, no upload.
DAX
Learn measures, functions, filter context, and advanced calculations.
Power Query
Master data transformation using M language and query techniques.
Data Modeling
Build efficient star schemas, relationships, and semantic models.
Microsoft Fabric
Explore Lakehouse, Warehouse, pipelines, and modern analytics.
Visuals
Design effective charts, tables, slicers, and custom formatting.
Power BI Service
Manage workspaces, dashboards, scheduled refresh, and security.
DAX Patterns
Ready-made patterns for totals, ranking, and running calculations.
AI-Assisted Power BI
Use AI to accelerate DAX, Power Query, modeling, and report development.
Governance
Reference sheets for RLS matrices, gateway architecture, and report themes.
From the Blog & Tutorials
Real fixes, cheat sheets, and full builds — not just reference pages.
Power Query Error: We Cannot Convert the Value Null to Type Table
This error means a step expected a table but received null instead — usually from a filter that matched nothing, a failed merge, or a source that returned nothing this time. Here's how to find which, and the fix for each.
Power Query Error: There Were Too Many Elements in the Enumeration to Complete the Operation
This cryptic error almost always comes from Table.Pivot hitting duplicate row/column combinations with no aggregation function to combine them. Here's what it actually means, and the fix.
This site talks to AI agents directly.
Every doc page is also available as a plain-text index, purpose-built for LLMs and coding assistants to read directly instead of scraping rendered HTML — llms.txt is an emerging convention several sites (including this one) already support.
$ curl https://pbidocs.com/llms.txt # Docs - Getting Started - [Getting Started] (/docs/getting-started): Start here to install Power BI Desktop and learn the basics. - AI-Assisted Power BI - [DAX with AI] (/docs/ai-power-bi/dax-with-ai): Use AI to write, explain, and debug DAX calculations faster. ...
Stay in the loop
New Power BI content, sent occasionally. No spam.
Just your email, nothing else. Privacy policy