Automating Power BI Documentation with DAX Info Functions
Proposed session for SQLBits 2026TL; 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.
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
Speakers
Cristian Prifti's other proposed sessions for 2026
Getting Started with the TMDL View - 2026
Mastering DAX Query View in Power BI - 2026
Organizational Themes and Visual Styles in Power BI - 2026
Preparing Your Data for AI: Copilot & Data Agents in Microsoft Fabric - 2026
Supercharge Your Data Workflow: Automating Power BI with Power Automate - 2026