22-25 April 2026

Programmatic Report and Model Changes with Python

Proposed session for SQLBits 2026

TL; DR

Learn how to use Python scripts to programmatically update Power BI reports and semantic models using PBIP, PBIR, and TMDL, bringing speed, control, and bulk changes into Power BI development.

Session Details

Power BI is no longer limited to point-and-click development. With PBIP, PBIR, and TMDL, reports and semantic models can be treated as code, opening the door to automation, consistency, and scale.

In this session, we focus exclusively on Python-driven automation for Power BI development. You’ll see how Python scripts can safely and deterministically modify Power BI report definitions and semantic models by working directly with PBIP, PBIR, and TMDL files.

We’ll explore real-world scenarios such as bulk visual updates, measure refactoring, naming standardization, and model fixes—showing why Python is often the fastest and safest option when precision matters. This session is aimed at practitioners who want full control over their changes without relying on manual edits.

3 things you'll get out of this session

By the end of this session, attendees will be able to: -> Understand how PBIP, PBIR, and TMDL enable code-based Power BI development -> Identify scenarios where Python automation is the safest and most efficient approach -> Use Python to apply repetitive and large-scale changes to reports and models

Speakers