AlexanderKornMS's avatar
AlexanderKornMS
Microsoft Employee
4 months ago

Semantic Link - Power BI Fixer

πŸ”§ Power BI Fixer β€” The All-in-One Development Environment for Power BI in Fabric

Author: Alexander Korn Β· Solution Engineer Data Platform @ Microsoft
Repository: github.com/KornAlexander/semantic-link-labs (branch: feature/pbi-fixer-ui)
Website: actionablereporting.com/pbi-fixer
Built on: Semantic Link Labs by Michael Kovalsky


πŸ“‹ Abstract

The Power BI Fixer is an interactive development environment that runs natively inside Microsoft Fabric Notebooks. It combines Semantic Link, ipywidgets, and TOM (Tabular Object Model) to provide a comprehensive tool for scanning, exploring, fixing, and documenting Power BI reports and semantic models β€” all from a single notebook cell.

The Problem It Solves

Power BI developers face a fragmented workflow:

  • Report issues (pie charts, missing data labels, page sizes) require manual visual-by-visual fixes in Power BI Desktop
  • Model best practices (missing descriptions, floating point types, foreign key visibility) need Tabular Editor or manual scripting
  • No single tool lets you scan a report AND its underlying model, see the results side-by-side, and fix everything in one workflow
  • PBIR format adoption is slow because upgrade tooling is scattered

The PBI Fixer addresses all of these by providing 12+ interactive tabs, 17 report fixers, 25+ semantic model fixers, and a unified scan-and-fix workflow β€” running entirely in a Fabric Notebook.

 

~17,000 lines of new Python code across 5 UI & tab modules (9,439 lines β€” incl. Fix All, Model Explorer, Report Explorer, Prototype, Translations, Model Diagram, About), 15 report fixers (3,038 lines), 4 report helpers (593 lines), and 33 semantic model fixers (3,797 lines) β€” all written from scratch for this project.


🎬 Demo Video

Watch the full walkthrough: Power BI Fixer v2 Demo on YouTube


 

 

No RepliesBe the first to reply