Solution Engineer Data Platform @ Microsoft | IBCS Certified Consultant
Helping businesses make better decisions through Actionable Reporting. Since 2016 I've been growing my Power BI experience in consulting, directly in the industry, and through the vendor perspective at Microsoft as Solution Engineer for the Data Platform. I leverage hands-on experience to support major migrations and help organizations unlock the full value of their data platforms through actionable reporting, optimized data models, and IBCS.
π§ pbi_fixer β Power BI Fixer for Semantic Models and Report Design
A Python-based Power BI Fixer that runs in Microsoft Fabric Notebooks with an interactive UI. Install with one line, launch with one line.
11 Fixers across two categories:
- Report Fixers (PBIR): Fix Pie Charts, Fix Bar Charts, Fix Column Charts, Fix Page Size, Hide Visual Filters
- Semantic Model Fixers (XMLA): Discourage Implicit Measures, Add Calendar Table, Add Measure Table, Add Last Refresh Table, Add Units Calc Group, Add Time Intelligence Calc Group
Three modes: Fix, Scan, Scan + Fix. Built on Semantic Link Labs.
π§° PBI-Tools β The Power BI Toolbox
A comprehensive toolkit for Power BI development with 80+ scripts, templates, and tools, organized into the following areas:
The core of this repo β 93 curated C# macros for Tabular Editor, organized into 10 categories:
| Category | What's Inside |
|---|---|
| Measure Create | Create explicit measures from columns, Time Intelligence (Y-1, Ξ Y-1, Ξ Y-1%), YTD, M-1, Replace Text in Measure |
| Measure Modify | Format strings, dynamic FormatStringExpression for units, set IsAvailableInMDX to false for IDs |
| Calc Tables | Calendar (TE2 & TE3), Empty Measure Table (TE2 & TE3), Value Parameters 1-10 |
| Calc Groups | Time Intelligence, Units, Time Intelligence with Value Parameter |
| Power Query | Create & Replace M Parameters |
| Model Refresh | Refresh whole model, selected tables, or partitions with Calculate |
| Utilities | Load BPA, DiscourageImplicitMeasures check, auto-organize into display folders, document model |
| Community Scripts | Official TE Library, Bernat AgullΓ³'s collection, Nordgaard's scripts |
Additional script tools:
- PIMP Script β PowerShell (
PIMP-Script.ps1) and C# (Power BI-Pimp-Script.csx) scripts that instantly add a Date Dimension, Last Refresh Table, Time Intelligence Calc Group, and Units Calc Group to any Power BI model - Macro Parser & Extractor β HTML tools to convert between
MacroActions.jsonand individual.csxfiles - Data Model Toolbox β HICO Data Model Toolbox macros with Stream Deck integration
- Other MacroActions.json collections β Curated configs from Alexander Korn, Eivind Haugen, Michael Kovalsky, and the Official TE + PBI Tips + Bernat bundle
- IBCS PBI Copilot β Full PBIP project (dataset + report) with IBCS-compliant template
- IBCS Power BI Generator β Standalone .exe
- IBCS Templates β Adventure Works and SVG-based IBCS .pbix templates
- Troubleshooting Tool β 926-line PowerShell data collector for PBIRS diagnostics (logs, configs, service checks)
- Monitoring Reports β PBIRS Monitoring and Job Monitoring .pbix files
- SQL Queries β Catalog dimension view, unused reports detection
- Bulk Download β Scripts to download all items from PBIRS folders
- Fabric Workspace Export/Import β PowerShell pipeline using FabricPS-PBIP to export and import workspace items
- Notebook Gallery β Fabric Notebook combining BPA + Memory Analyzer + Lakehouse persistence
- VertiPaq Analyzer SQL Views β Column, Relationship, Summary, and Table views for VertiPaq analysis
- Table Templates β Ready-to-use TMDL files: Calendar, Calendar (Calc Table), Last Refresh, Measure Table, Time Intelligence, Units
- TMDL Repo β Community Power Query functions (Calendar by Lars Schreiber)
- Calculation Group Time Intelligence β Standalone .bim template
- LinkedIn Report Templates β LinkedIn Connections and Ultimate LinkedIn Report .pbit files
β‘ PowerShell β General Utility Scripts
A collection of PowerShell scripts for everyday IT automation β not Power BI specific:
| Category | Scripts |
|---|---|
| SQL | Deploy multiple .sql files to SQL Server with auto-archival |
| Active Directory | AD group member queries, recursive parent group lookup, user searches, CSV exports |
| File Management | Archive rotation, subfolder creation, file check + email alerts, Excel data refresh, folder listing |
| Outlook | Scan saved .msg files for keywords |
I speak at community events about Power BI tooling, data modeling, and report server internals.
Past events include Power BI Summit 2024, New Stars of Data 2023, HICO Vision-X-Future (Frankfurt & ZΓΌrich), Reid Havens Podcast, and AI or DIE Thinkers Talk with Artur KΓΆnig & Marcus Wegener.