Changelog

A running record of meaningful additions and fixes to the Power BI content on this site. Site design, theming, and infrastructure changes aren't tracked here.

2026-09-04 – 2026-09-05

–Added four new DAX Patterns pages built around real systems and program engineering scenarios, each paired with its full tutorial walkthrough: Earned Value Management (EVM) Metrics, Risk Score & Heat Map, Coverage & Verification (Requirements Traceability), and Reliability Metrics (MTBF, MTTR & Availability).
–Switched the documentation section to a new layout with a tabbed navbar (Get Started, DAX, Power Query, Modeling & Visuals, Service & Governance) for faster jumping between topics, and made better use of the screen on wide monitors.

2026-09-02 – 2026-09-04

–Added 10 more interactive "Try it live" playgrounds to the Power Query and DAX references, bringing the total to 32 live examples across the site: DateTime.LocalNow(), List.Distinct() & List.Contains(), LEFT(), RIGHT() & MID(), BLANK() vs 0, TRIM(), UPPER() & LOWER(), DATEDIFF(), CALENDAR() vs CALENDARAUTO(), DATEADD() vs PARALLELPERIOD(), UNION(), EXCEPT() & INTERSECT(), and TODAY() & NOW(): Calculated Column vs Measure Timing.

2026-08-29

–Closed a major documentation gap between DAX and Power Query: added 19 full Power Query M pages covering table, list, text, and custom functions, error handling, date/duration functions, and source connectors — including Custom Functions, Table.TransformColumnTypes(), List.Accumulate(), Error Handling (try...otherwise), and Sql.Database(). Each linked from the M Function Reference.
–Added two more error-message posts: There Were Too Many Elements in the Enumeration (a Table.Pivot duplicate-key error) and We Cannot Convert the Value Null to Type Table.
–Added a dedicated Pricing page for the DAX Formula Builder and Ask AI Pro tier, linked from the main navigation.

2026-08-27 – 2026-08-28

–Added four more Power Query pages closing the biggest remaining gaps: Table.SelectRows(), Table.AddColumn(), Table.Pivot() & Table.Unpivot(), and Merge vs. Append.
–Added six more error-message blog posts, continuing the pattern of titling posts after the literal error text: Web.Contents Can Only Accept a Literal String, There Isn't Enough Memory to Complete This Operation, OLE DB or ODBC Error, and DAX Comparison Operations Do Not Support....

2026-08-26

–Launched Ask AI — a page-scoped AI chat panel on every documentation page, free up to 5 questions a day.

2026-08-24 – 2026-08-25

–Launched the DAX Formula Builder — describe a calculation or transformation in plain English and get back a real DAX measure or Power Query M step, free up to 5 requests a day.
–Added DAX User-Defined Functions (UDFs), DIVIDE, IF, SUMX, COUNTROWS, DISTINCTCOUNT, and EARLIER.
–Added two new tutorials: Build a Risk Register Dashboard and Build a Reliability (MTBF/MTTR) Dashboard.

2026-08-11

–Added a DAX Function Reference — a categorized index of common DAX functions, linking to the full explanations where available.
–Launched the Blog — practical fixes and cheat sheets, starting with Fix a Circular Dependency in DAX, Power Query's "field wasn't found" error , and a DAX Time Intelligence Cheat Sheet.

2026-08-10

–Built out the Microsoft Fabric section: OneLake, Lakehouse, Data Warehouse, Data Factory, Direct Lake Mode, and Fabric Capacity & Cost Management.
–Added RELATED & RELATEDTABLE, LOOKUPVALUE, SELECTEDVALUE, SWITCH, RANKX, TOPN, SUMMARIZE, USERELATIONSHIP, and Performance Optimization.
–Filled in several placeholder pages that had little or no real content, across Modeling, Power Query, and AI-Assisted Power BI.
–Added worked Advanced Editor examples: error handling with try...otherwise, and what a UI-built merge actually generates.
–Fixed 11 broken internal links and wired two pages that existed but weren't reachable from navigation back into the site.

2026-08-06

–Added Microsoft Fabric — OneLake, core workloads (Lakehouse, Warehouse, Data Factory, Real-Time Intelligence), and how Direct Lake connects Power BI to Fabric data.
–Added a documentation landing page at /docs, which previously had no page of its own.
–Added a Governance section — RLS Role Matrix, Gateway & Refresh Architecture, and Report Theme JSON Files.

2026-08-05

–Added Dataflows, Deployment Pipelines, Field Parameters, and Aggregations.
–Added Composite Models — combining multiple data sources in one model, cross-source relationships, and query performance.

2026-08-04

–Added Row-Level Security — static vs. dynamic RLS, USERPRINCIPALNAME()-based dynamic security, and common mistakes.
–Added DirectQuery vs. Import — storage modes, composite models, and when to use each.
–Added Bookmarks & Interactivity — bookmarks, drill-through, and report page tooltips.
–Added the remaining Power BI Service pages: Workspaces, Dashboards, Refresh.
–Added the remaining Visuals pages: Charts, Tables, Slicers, Formatting.
–Added the remaining DAX Patterns pages: Totals, Ranking, Percent of Total, Running Total.
–Added Calculated Tables, the remaining Power Query pages (Introduction, Transformations, Query Folding), and the remaining Getting Started pages (Installation, Power BI Overview).
–Fixed several DAX and Power Query code examples that were mislabeled as SQL, which gave them incorrect syntax highlighting.

2026-08-03

–Fixed garbled characters (arrows, em dashes, checkmarks) across 9 pages, left behind by a prior encoding issue.
–Fixed stray leftover text and formatting issues in the Power Query content.

2026-07-31 – 2026-08-02

–Added Iterator Functions (X Functions) and Variables (VAR).
–Updated Time Intelligence content and fixed frontmatter formatting issues.

2026-07-30

–Initial launch of the PBIDocs Power BI documentation site.