22-25 April 2026

Automating Power BI Documentation with DAX Info Functions

Proposed session for SQLBits 2026

TL; DR

Learn how to automate Power BI model documentation using DAX Info functions and Power Automate—no external tools required.

Session Details

Documenting Power BI models is often seen as boring and time-consuming. In this session, you’ll learn how the latest DAX Info functions can make model documentation much easier and fully automated. We’ll show how to extract metadata about tables, measures, relationships, and partitions directly from Power BI—without relying on external tools or IT approvals.

Through practical examples, you’ll see how Info and Info.View functions can be used to build structured model documentation. We’ll also look at how to combine and enrich this information using techniques like NATURALLEFTOUTERJOIN, and how to automate the entire process with Power Automate for ongoing, up-to-date documentation.

3 things you'll get out of this session

- Use DAX Info and Info.View functions to extract Power BI model metadata - Combine and enrich metadata into structured documentation - Automate documentation updates using Power Automate