Skip to content

Releases

AE Power BI Multi-Tool Suite - Version 2.3.0

Choose a tag to compare

@ae-reid-havens ae-reid-havens released this 23 Jun 18:43

AE Power BI Multi-Tool Suite - Version 2.3.0 Release Notes

Release Date: June 2026
Version: v2.3.0 - Accessibility Checker Edition


Overview

Version 2.3.0 introduces the Accessibility Checker Tool, a comprehensive WCAG compliance analyzer for Power BI reports. This tool scans reports for accessibility issues including tab order, alt text, color contrast, page titles, visual titles, and more.

This release also removes the Table Column Widths Tool. Power BI Desktop now provides native table and matrix column auto-sizing, making the dedicated tool redundant.


Removed

Table Column Widths Tool

Removed from the suite. Power BI Desktop's native table and matrix column auto-sizing now covers this functionality, so the standalone tool is no longer needed. Existing reports are unaffected; manage column widths directly in Power BI Desktop going forward.


What's New

Accessibility Checker Tool - Major New Feature

A professional accessibility compliance analyzer that scans Power BI reports for WCAG 2.1 conformance issues and provides actionable recommendations.

Check Types

Check Description WCAG Reference
Tab Order Validates keyboard navigation sequence 2.4.3 Focus Order
Alt Text Detects missing or generic alt text on visuals 1.1.1 Non-text Content
Color Contrast Analyzes text/background contrast ratios 1.4.3 Contrast (AA), 1.4.6 (AAA)
Page Titles Identifies generic or missing page titles 2.4.2 Page Titled
Visual Titles Checks for descriptive visual titles Best Practice
Data Labels Verifies data label accessibility Best Practice
Bookmark Names Flags generic bookmark names Best Practice
Hidden Pages Warns about hidden page accessibility Best Practice

Color Contrast Analysis

  • WCAG AA Normal Text - 4.5:1 minimum ratio
  • WCAG AA Large Text - 3.0:1 minimum (18pt+ or 14pt+ bold)
  • WCAG AAA Normal Text - 7.0:1 enhanced ratio
  • WCAG AAA Large Text - 4.5:1 enhanced ratio
  • UI Components - 3.0:1 for graphical objects
  • Transparency Handling - Calculates blended colors for layers

Severity Levels

  • ERROR - Critical issues that fail WCAG compliance
  • WARNING - Should fix for better accessibility
  • INFO - Suggestions and best practices

Visual Classification

  • Data Visuals - Charts, tables, KPIs, cards, slicers requiring accessibility attention
  • Decorative Visuals - Shapes, textboxes, images with different requirements
  • Automatic Detection - Identifies 30+ visual types

Tab Order Analysis

Comprehensive keyboard navigation validation.

  • Sequence Verification - Validates logical reading order
  • Missing Tab Orders - Identifies visuals without explicit tab order
  • Position Mapping - Correlates tab order with visual position
  • Group Awareness - Handles visual groups and nesting
  • Z-Order Analysis - Considers visual layering

Alt Text Validation

Intelligent alt text quality checking.

  • Missing Detection - Finds visuals without alt text
  • Generic Pattern Detection - Flags generic text like "image", "chart", "visual"
  • Data Visual Requirements - Stricter checks for data-bearing visuals
  • Decorative Handling - Appropriate rules for decorative elements

Page & Bookmark Analysis

Quality checks for navigation elements.

  • Generic Page Titles - Detects "Page 1", "Sheet 1", "Untitled" patterns
  • Generic Bookmarks - Flags "Bookmark 1", "BM1" style names
  • Hidden Page Warnings - Alerts when pages are hidden but may need accessibility
  • Display Name Validation - Ensures meaningful names for screen readers

Export & Reporting

Professional compliance documentation.

  • JSON Export - Full analysis results in structured format
  • Summary Reports - Issue counts by type and severity
  • Per-Page Breakdown - Issues organized by report page
  • Audit Trail - Timestamps and analysis duration tracking

How to Use Accessibility Checker

Quick Start

  1. Open the Multi-Tool and select Accessibility Checker
  2. Select your PBIP report file
  3. Configure which checks to run (all enabled by default)
  4. Analyze - tool scans all pages and visuals
  5. Review issues by severity, type, or page
  6. Export report for compliance documentation

Interpreting Results

  • Red (ERROR) - Must fix for WCAG compliance
  • Yellow (WARNING) - Should fix for better accessibility
  • Blue (INFO) - Suggestions for improvement

Fixing Issues

Each issue includes:

  • Description - What the issue is
  • Location - Page and visual name
  • Current Value - What was found (e.g., contrast ratio)
  • Recommendation - How to fix it
  • WCAG Reference - Relevant guideline

Technical Details

New Files

File Purpose
tools/accessibility_checker/ Complete Accessibility Checker module
accessibility_analyzer.py Core analysis engine
accessibility_types.py Data models and enums
accessibility_config.py Configuration and thresholds
accessibility_ui.py User interface components

Architecture

The Accessibility Checker follows a clean separation of concerns:

  1. Types Layer - Data classes for issues, results, visual info
  2. Analyzer Layer - Core scanning and validation logic
  3. Config Layer - Thresholds and check configurations
  4. UI Layer - Tkinter interface with filtering and export

Upgrade Path

From v2.2.0 to v2.3.0

  1. Download the new AE Power BI Multi-Tool.exe (v2.3.0)
  2. Replace your existing executable
  3. No configuration migration needed

Breaking Changes

  • None - Fully backward compatible with v2.2.0

Support

Need Help?

WCAG Resources


Version History

v2.3.0 - Accessibility Checker Edition (Current)

  • NEW: Accessibility Checker Tool - WCAG compliance analyzer
  • Tab Order Analysis - Keyboard navigation validation
  • Alt Text Validation - Missing and generic alt text detection
  • Color Contrast Analysis - WCAG AA/AAA contrast checking with transparency
  • Page Title Checks - Generic page title detection
  • Visual Title Checks - Title presence and quality validation
  • Bookmark Name Analysis - Generic bookmark name flagging
  • Hidden Page Warnings - Accessibility considerations for hidden pages
  • Export Reports - JSON export for compliance documentation

v2.2.0 - Connection Hot Swap Edition

  • Connection Hot Swap Tool - Dynamic connection switching
  • Cloud Workspace Browser - OAuth-integrated dataset selection
  • Preset System - Global and model-scoped configurations
  • Thin Report Support - PBIP file modification

v2.1.0 - Field Parameters Edition

  • Field Parameters Tool - Visual parameter creation and editing
  • Multi-level categories - Unlimited hierarchy support
  • Grouped view - Collapsible category groups
  • Virtual scrolling - 500+ field performance

v2.0.0 - UI Redesign & Cleanup Edition

  • UI: Dark/Light Mode - Full theme support
  • UI: Sidebar Redesign - Improved navigation
  • Report Cleanup Enhancements - Duplicate/unused image detection
  • Layout Optimizer Enhancements - Multi-diagram support

v1.3.1 - Cross-Page Bookmark Edition

  • Cross-Page Bookmark Mode for multi-page popup control

v1.2.0 - Sensitivity Scanner Edition

  • Sensitivity Scanner Tool for TMDL security analysis

v1.1.1 - Advanced Copy Enhancement Edition

  • Enhanced page copying with bookmark management

v1.0.0 - Enhanced Report Cleanup Edition

  • Enhanced Table Column Widths with Fit to Totals defaults

Made with care and AI by Reid Havens for the Power BI professional community

Empowering data professionals with AI-enhanced, enterprise-grade tools for Power BI excellence

AE Power BI Multi-Tool Suite - Version 2.2.0

Choose a tag to compare

@ae-reid-havens ae-reid-havens released this 06 May 20:20

AE Power BI Multi-Tool Suite - Version 2.2.0 Release Notes

Release Date: May 2026
Version: v2.2.0 - Connection Hot Swap Edition


Overview

Version 2.2.0 introduces the Connection Hot Swap tool for dynamic Power BI connection management, allowing you to switch between development and production environments without republishing reports.


What's New

Connection Hot Swap Tool - Major New Feature

A professional-grade connection management tool for dynamically switching Power BI data source connections between environments without republishing reports.

Key Use Cases

  • Environment Switching: Quickly swap between Dev/Test/Prod datasets
  • Thin Report Development: Connect cloud-published reports to local models
  • Cloud Migration: Move reports between workspaces or tenants
  • Offline Development: Work with local copies of cloud models
  • Team Collaboration: Share preset configurations across teams

Supported Scenarios

Model Type Swap Direction Method Notes
Composite Model Cloud to Local TOM modification Hot-swap while open in Desktop
Composite Model Local to Cloud TOM modification Hot-swap while open in Desktop
Composite Model Cloud to Cloud TOM modification Hot-swap while open in Desktop
Thin Report Cloud to Local File modification Requires PBIP format
Thin Report Local to Cloud File modification Requires PBIP format

Key Distinction:

  • Composite Models: Can hot-swap while the report is open in Power BI Desktop (TOM-based modification)
  • Thin Reports: Require PBIP format for file-based swapping (PBIP can be modified while open; PBIX requires closing)

Workspace Support:

  • Perspectives work in ALL workspace types: Pro, Premium, PPU, and Fabric
  • Cloud-to-cloud swapping enables switching between datasets, workspaces, or connection types

Cloud Workspace Browser

Full Power BI Service integration with OAuth authentication.

  • OAuth via MSAL - Secure Microsoft authentication
  • Persistent Token Cache - Silent re-authentication across sessions
  • Workspace Views - All / Favorites / Recent
  • Cross-Workspace Search - Find datasets across all accessible workspaces
  • Manual XMLA Entry - Direct endpoint URL input
  • Perspective Selection - Choose specific perspectives (works in Pro, Premium, PPU, and Fabric)
  • Cloud-to-Cloud Swapping - Switch between cloud datasets, workspaces, or connection types

Smart Local Model Matching

Automatic discovery of open Power BI Desktop instances with intelligent matching.

  • Exact Match - Names match exactly (case-insensitive)
  • Contains Match - One name contains the other
  • Fuzzy Match - SequenceMatcher with 60% threshold
  • Port Detection - Fast discovery via port files
  • Window Title Parsing - Friendly names from Desktop windows

Preset System

Comprehensive configuration persistence for quick environment switching.

Preset Scopes

Scope Description Use Case
Global Single target, works across any model "Always use Prod dataset"
Model Full mapping snapshot for specific report "Dev config for Sales Report"

Storage Locations

Location Path Use Case
USER %APPDATA%/Analytic Endeavors/... Personal presets
PROJECT .pbi-hotswap/ folder Team-shared presets
REPORT Embedded in PBIP Report-specific config

Last Config Memory

Automatically remembers your last successful configuration per model for quick re-application.


Thin Report Support

Full support for reports without embedded models (thin reports).

  • PBIP Format Required - Direct JSON file editing
  • PBIP Advantage - File can be modified while Desktop has it open (no file lock)
  • PBIX Limitation - Requires closing Power BI Desktop before modification (file locked)
  • Reload Required - All thin reports require close/reopen after swap to pick up changes
  • Automatic Backups - Timestamped backup files before modification
  • Cloud Schema Preservation - Original connection format cached for restoration

Note: Unlike composite models which can true hot-swap while open, all thin reports require closing and reopening the report after the swap. PBIP format is recommended because it allows the file to be modified without closing Desktop first.


Persistent Cloud Connection Cache

Cloud connection schemas are now cached to disk, surviving application restarts.

The Problem Solved

Previously, cloud connection fields like PbiServiceModelId, PbiModelVirtualServerName, etc. were cached only in memory. When the app restarted, these fields were lost, resulting in generic connections with null values.

How It Works

  • Cloud-to-Local Swap: Original cloud connection cached to memory AND disk
  • Local-to-Cloud Swap:
    • Tries memory cache first, then disk cache
    • If cached: restores EXACT original format with all fields
    • If no cache: generates generic connection WITH warning message
  • App Restart: Disk cache automatically loaded into memory

Key Fields Preserved

{
  "PbiServiceModelId": 16589041,
  "PbiModelVirtualServerName": "sobe_wowvirtualserver",
  "PbiModelDatabaseName": "f1a05c34-cb7e-4b08-bd82-fdf6d8412be1",
  "ConnectionType": "pbiServiceLive"
}

Schema Fingerprinting & Validation

Automatic detection of schema changes with user-friendly resolution options.

Schema Fingerprint

Each cloud connection has a fingerprint based on key fields for change detection.

Preset Validation

When applying a preset, schema fingerprints are compared:

  1. Match: Preset applied normally
  2. Mismatch: Warning dialog appears with options:
    • Update Preset: Update preset with current schema, then apply
    • Apply Anyway: Apply preset's stored connection (may have issues)
    • Cancel: Abort the operation

Backward Compatibility

  • Old presets without fingerprints still work
  • Validation is skipped when no fingerprint exists
  • New presets automatically include fingerprints

Safety Features

Comprehensive protection for your reports and connections.

  • Automatic Backups - Timestamped file backups before modification
  • Swap History - Full audit trail with rollback capability
  • Schema Validation - Warnings for potential compatibility issues
  • Health Monitoring - Target accessibility verification
  • TOM Verification - Confirms changes persisted after swap
  • Rollback on Error - Automatic restoration if swap fails

How to Use Connection Hot Swap

Quick Start

  1. Open the Multi-Tool and select Connection Hot Swap
  2. Connect to a model open in Power BI Desktop
  3. View detected connections in the connection diagram
  4. Select target (local model or cloud dataset)
  5. Swap - connection updated instantly

Thin Report Workflow

  1. Select your thin report file (.pbix or .pbip)
  2. Cache original cloud connection (automatic)
  3. Swap to Local for development
  4. Swap to Cloud when ready - exact original format restored

Preset Workflow

  1. Configure your target connections
  2. Save as Global or Model preset
  3. Apply preset anytime for instant environment switch

Technical Details

New Files

File Purpose
tools/connection_hotswap/ Complete Hot Swap tool module
logic/connection_cache.py Persistent disk cache manager
ui/dialogs/schema_mismatch_dialog.py Schema mismatch warning dialog

Architecture

The Hot Swap tool follows a clean three-layer architecture:

  1. Models Layer - Pure data classes with serialization
  2. Logic Layer - Business operations (no UI dependencies)
  3. UI Layer - Tkinter interface calling into logic layer

Upgrade Path

From v2.1.0 to v2.2.0

  1. Download the new AE Power BI Multi-Tool.exe (v2.2.0)
  2. Replace your existing executable
  3. No configuration migration needed
  4. Cloud connection cache builds automatically on first use

Breaking Changes

  • None - Fully backward compatible with v2.1.0

Support

Need Help?


Version History

v2.2.0 - Connection Hot Swap Edition (Current)

  • NEW: Connection Hot Swap Tool - Dynamic connection switching for Power BI
  • NEW: Cloud Workspace Browser - OAuth-integrated dataset selection
  • NEW: Preset System - Global and model-scoped configurations
  • NEW: Thin Report Support - PBIP file modification (PBIP can be modified while open)
  • NEW: Pro Workspace Perspectives - Connect to perspectives in any workspace type
  • NEW: Cloud-to-Cloud Swapping - Switch between cloud datasets or connection types
  • NEW: Persistent Cloud Schema Cache - Survives app restart
  • NEW: Schema Mismatch Detection - Warning dialog with update option
  • Composite Models: Hot-swap while open in Desktop (TOM-based)
  • Thin Reports: Require PBIP format for file-based swapping

v2.1.0 - Field Parameters Edition

  • Field Parameters Tool - Visual parameter creation and editing
  • Multi-level categories - Unlimited hiera...
Read more

Field Parameters Tools Release

Choose a tag to compare

@ae-reid-havens ae-reid-havens released this 25 Mar 20:39

AE Power BI Multi-Tool Suite - Version 2.1.0 Release Notes

Release Date: April 2026
Version: v2.1.0 - Field Parameters Edition


Overview

Version 2.1.0 introduces the Field Parameters Tool, a comprehensive visual interface for creating and editing Power BI Field Parameters with drag-and-drop reordering, multi-level category hierarchies, and real-time TMDL code generation.


What's New

Field Parameters Tool - Major New Feature

A professional visual interface for creating and managing Power BI Field Parameters without manual DAX coding.

Core Features

  • Visual parameter builder - Drag-and-drop interface for creating Power BI Field Parameters
  • Multi-level categories - Unlimited category hierarchies with custom column names
  • Grouped view - Collapsible category groups with drag-to-reorder within groups
  • Virtual scrolling - Handles 500+ fields with smooth performance
  • Category filtering - Multi-select filter by category with expandable menu
  • TMDL generation - Real-time code preview with proper formatting

Field Management

  • Display name editing - Double-click inline editing with bulk revert option
  • Lineage tag preservation - Maintains IDs when editing existing parameters
  • Extra column preservation - Keeps non-standard calculated columns intact
  • Drag-and-drop reordering - Intuitive field organization

Category System

  • Category Manager panel - Create, edit, and delete categories
  • Bulk category assignment - "Edit Categories" button opens table editor for all fields
  • Category dropdowns - Quick assignment via dropdowns in the field list
  • Hierarchy support - Create parent-child category relationships

How to Use Field Parameters

Creating Field Parameters

  1. Connect to a semantic model (External Tool or manual selection)
  2. Choose mode: "Create New" or "Edit Existing"
  3. Add fields from Available Fields panel (double-click or drag)
  4. Set display names (double-click to edit inline)
  5. Create categories using Category Manager panel
  6. Assign fields to categories via category dropdowns or table editor
  7. Reorder by dragging fields or groups
  8. Copy TMDL code to clipboard for Tabular Editor

Advanced Features

  • Grouped View: Switch to "Grouped" mode to see fields organized by category
  • Category Filtering: Use filter dropdown to show only specific categories
  • Bulk Category Assignment: "Edit Categories" button opens table editor for all fields
  • Virtual Scrolling: Automatically enabled for 100+ fields

Technical Details

New Files

File Purpose
tools/field_parameters/ Complete Field Parameters tool module
field_parameters_tool.py Main tool registration and entry point
field_parameters_ui.py User interface components
field_parameters_core.py Core logic and data management
field_parameters_builder.py TMDL code generation
field_parameters_connector.py Model connection handling
models.py Data models for fields and categories
panels.py UI panel components
dialogs.py Dialog windows
widgets.py Custom UI widgets

Architecture

The Field Parameters tool follows a modular architecture:

  1. Models - Pure data classes for fields, categories, and parameters
  2. Core - Business logic separated from UI
  3. UI - Tkinter interface with reusable widgets
  4. Builder - TMDL code generation with proper formatting

Upgrade Path

From v2.0.0 to v2.1.0

  1. Download the new AE Power BI Multi-Tool.exe (v2.1.0)
  2. Replace your existing executable
  3. No configuration migration needed

Breaking Changes

  • None - Fully backward compatible with v2.0.0

Support

Need Help?


Version History

v2.1.0 - Field Parameters Edition (Current)

  • NEW: Field Parameters Tool - Visual parameter creation and editing
  • Multi-level categories - Unlimited hierarchy support
  • Grouped view - Collapsible category groups
  • Virtual scrolling - 500+ field performance
  • TMDL generation - Real-time code preview
  • Drag-and-drop - Intuitive field reordering

v2.0.0 - UI Redesign & Cleanup Edition

  • UI: Dark/Light Mode - Full theme support
  • UI: Sidebar Redesign - Improved navigation
  • Report Cleanup: Duplicate Images - MD5 hash detection
  • Report Cleanup: Unused Images - Find unreferenced images
  • Report Cleanup: Saved Scripts - Remove DAX queries and TMDL scripts
  • Layout Optimizer: Multi-Diagram - Optimize any saved diagram

v1.3.1 - Cross-Page Bookmark Edition

  • Cross-Page Bookmark Mode for multi-page popup control

v1.2.0 - Sensitivity Scanner Edition

  • Sensitivity Scanner Tool for TMDL security analysis

v1.1.1 - Advanced Copy Enhancement Edition

  • Enhanced page copying with bookmark management

v1.0.0 - Enhanced Report Cleanup Edition

  • Enhanced Table Column Widths with Fit to Totals defaults

Made with care and AI by Reid Havens for the Power BI professional community

Empowering data professionals with AI-enhanced, enterprise-grade tools for Power BI excellence

v2.0.0

Choose a tag to compare

@ae-reid-havens ae-reid-havens released this 04 Mar 19:21

Release Date: January 2026
Version: v2.0.0 - UI Redesign & Cleanup Edition


Overview

Version 2.0.0 is a major release introducing a comprehensive UI redesign with dark/light mode support and consistent theming across all tools, plus significant enhancements to the Report Cleanup Tool and Layout Optimizer.


What's New

Report Cleanup Tool Enhancements - Major Update

Added support for cleaning up development artifacts and optimizing images in the report.

Duplicate Image Detection

  • MD5 Hash Detection: Identifies images with identical content across the report
  • Config Dialog: Visual thumbnail preview with radio buttons to select which image to keep
  • Reference Consolidation: Automatically updates all visual and page references to the keeper
  • Smart Auto-Selection: Defaults to shortest filename as the keeper (customizable)
  • Size Savings: Shows potential space savings from removing duplicates

Unused Image Cleanup

  • Reference Scanning: Scans all visual.json and page.json files for image references
  • Orphan Detection: Finds files in RegisteredResources not registered in report.json
  • Safe Removal: Deletes unused files and updates report.json resource entries
  • Size Tracking: Reports bytes freed for each removed image

Saved Scripts Cleanup

  • DAX Queries: Remove saved queries from SemanticModel/DAXQueries folder
  • TMDL Scripts: Remove saved scripts from SemanticModel/TMDLScripts folder
  • Manifest Updates: Automatically updates tabOrder and defaultTab in manifests
  • Combined UI: New "Saved Scripts" card groups both types together
  • Size Tracking: Reports bytes freed for each removed file

These are development artifacts created when using DAX Query View and TMDL View in Power BI Desktop - safe to remove before publishing.


Layout Optimizer Enhancements - Major Update

Significant improvements to diagram layout optimization capabilities.

Multi-Diagram Support

  • Any Layout: Apply optimization to any saved diagram, not just the default "All tables"
  • Multi-Select: Choose multiple diagrams to optimize in a single operation
  • Bulk Operations: "Select All" and "Deselect All" for quick selection
  • Status Indicator: Shows "Selected: X of Y diagrams"

Improved Scoring Accuracy

  • Relationship-Aware: 30-point component based on table clustering and grouping quality
  • Size-Adjusted Metrics: Spacing thresholds scale dynamically with model size
  • Small Model Handling: Diagrams with 1-3 tables get fair assessment (alternative scoring)
  • Multi-Factor System: 100-point scoring across positioning, overlaps, spacing, efficiency, and relationships
  • Per-Diagram Analysis: Individual quality scores with ratings (EXCELLENT to VERY BAD)

UI Redesign

Dark/Light Mode

  • Full dark and light theme support across all tools
  • Consistent color palette with proper contrast ratios
  • Theme toggle in application settings

Sidebar Navigation

  • Redesigned sidebar for intuitive tool navigation
  • Collapsible sections for better organization
  • Visual tool status indicators

Consistent Theming

  • Unified color system via ThemeManager
  • Consistent button styling with hover effects
  • Proper spacing and visual hierarchy
  • Rounded buttons and improved scrollbars

Upgrade Path

From v1.3.1 to v2.0.0

  1. Download the new AE Power BI Multi-Tool.exe (v2.0.0)
  2. Replace your existing executable
  3. No configuration migration needed

Breaking Changes

  • None - Fully backward compatible with v1.3.x

Support

Need Help?


Version History

v2.0.0 - UI Redesign & Cleanup Edition (Current)

  • UI: Dark/Light Mode - Full theme support
  • UI: Sidebar Redesign - Improved navigation
  • UI: Consistent Theming - Unified color system across all tools
  • Report Cleanup: Duplicate Images - MD5 hash detection with config dialog to select keeper
  • Report Cleanup: Unused Images - Find unreferenced images including orphan files
  • Report Cleanup: Saved Scripts - Remove DAX queries and TMDL scripts from semantic model
  • Layout Optimizer: Multi-Diagram - Optimize any saved diagram layout, not just default
  • Layout Optimizer: Improved Scoring - Relationship-aware 100-point scoring system

v1.3.1 - Cross-Page Bookmark Edition

  • NEW: Cross-Page Bookmark Mode - Configure bookmarks to work across multiple pages
  • NEW: Cross-page UI indicator - Link icon, page count, and hover tooltip
  • NEW: Bookmark navigator copying - Navigators copied for cross-page mode
  • Bug fix - Cross-page bookmarks now work on target pages (visualContainerGroups)
  • Bug fix - Bookmarks no longer disappear after cross-page copy (comma-separated activeSection)

v1.2.0 - Sensitivity Scanner Edition

  • Sensitivity Scanner Tool for TMDL security analysis
  • 50+ detection patterns for PII, credentials, infrastructure
  • Rule Manager with Simple and Advanced modes

v1.1.1 - Advanced Copy Enhancement Edition

  • Enhanced page copying (multi-page, within/across PBIPs)
  • Advanced bookmark management with action reassignment
  • NEW: Bookmark + Visual (Popup) Copier

v1.0.0 - Enhanced Report Cleanup Edition

  • Enhanced Table Column Widths with Fit to Totals defaults
  • Matrix optimization with hierarchy-aware spacing

Made with care and AI by Reid Havens for the Power BI professional community

Empowering data professionals with AI-enhanced, enterprise-grade tools for Power BI excellence

πŸ”Ž Added Sensivity Scanner Tool

Choose a tag to compare

@ae-reid-havens ae-reid-havens released this 22 Nov 22:01

πŸš€ AE Power BI Multi-Tool Suite - Version 1.2.0 Release Notes

Release Date: November 17, 2025
Version: v1.2.0 - Sensitivity Scanner Edition


🎯 Overview

Version 1.2.0 introduces the brand new Sensitivity Scanner Tool, a comprehensive static analysis tool for detecting sensitive content in Power BI semantic models before sharing with LLMs or external parties. This powerful addition helps organizations ensure data security and compliance by identifying PII, credentials, financial data, and infrastructure details within TMDL files.


✨ What's New

πŸ” NEW: Sensitivity Scanner Tool

A professional-grade tool for scanning Power BI PBIP files to detect sensitive content in semantic models.

Core Features

  • βœ… Pattern-based detection: 50+ regex patterns for comprehensive coverage
  • βœ… Risk assessment: Categorizes findings as HIGH/MEDIUM/LOW with confidence scores
  • βœ… Intelligent deduplication: Combines multiple findings from same location (e.g., connection strings)
  • βœ… Power BI recommendations: Actionable, Power BI-specific guidance for remediation
  • βœ… Export functionality: Generate detailed findings reports for compliance/audit
  • βœ… Category scanning: Full scan or targeted scans (tables, RLS roles, expressions only)
  • βœ… Static analysis: Analyzes model structure, not actual data values

Detection Categories

HIGH RISK Patterns (17):

  • Personal Identifiable Information (PII): SSN, passport numbers, driver's licenses
  • Financial Data: Credit cards, bank accounts, tax IDs (TIN, EIN, ITIN)
  • Healthcare: Medical record numbers (MRN), patient IDs
  • Credentials: Passwords, API keys (OpenAI, Azure, AWS), connection strings
  • Security: OAuth tokens, bearer tokens, private keys, encryption keys

MEDIUM RISK Patterns (19):

  • Compensation: Salary, bonus, commission, stock options
  • Personal Data: DOB, employee IDs, biometric data, background checks
  • Infrastructure: Server names, IP addresses, MAC addresses, file paths (Windows/UNC)
  • Security Expressions: RLS using USERNAME() or USERPRINCIPALNAME()
  • Cloud: Azure connection strings, AWS credentials, JWT tokens

LOW RISK Patterns (14):

  • Identity: Name columns, address columns, emergency contacts
  • Demographics: Department, marital status, race/ethnicity, gender, disability status
  • Organizational: Company references, client names, division, veteran status, union membership

Power BI-Specific Intelligence

The scanner provides targeted Power BI recommendations for each finding:

Example - API Keys:

CRITICAL: Remove API key immediately.

Power BI Best Practice: Store API keys in Power Query parameters 
(Home > Manage Parameters > New Parameter). PBIT files automatically 
clear parameter values on save, protecting credentials. For deployed 
reports, use gateway credentials or Azure Key Vault integration.

Example - RLS Expressions:

MEDIUM RISK: Row-Level Security expression detected. 

Power BI Best Practice: Review RLS logic for correctness. Test with 
'View As' role feature (Modeling > View As) before publishing. Ensure 
USERNAME() or USERPRINCIPALNAME() matches expected format.

Intelligent Deduplication

Connection strings and complex expressions often trigger multiple patterns. The scanner now combines these intelligently:

Before Deduplication:

Finding #8: Connection String with Credentials (Password=Secret123!)
Finding #9: Connection String with Credentials (User ID=admin)
Finding #10: Connection String with Credentials (Server=PRODDB01)

After Deduplication:

Finding #8: Connection string with multiple embedded credentials: 
           User ID, Password, Server

This reduces noise and provides clearer, more actionable reports.


🎨 UI & UX Improvements

Compact Responsive Layout

The Sensitivity Scanner features a professional, space-optimized interface:

β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”
β”‚ πŸ“ SENSITIVITY SCANNER SETUP                            β”‚
β”‚ PBIP File: [____________] [Browse] [SCAN]              β”‚
β”‚ Scan Mode: β—‹ Full  β—‹ Tables  β—‹ RLS  β—‹ Expressions     β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ πŸ“Š SCAN RESULTS (60% of vertical space)                β”‚
β”‚ β”Œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β” β”‚
β”‚ β”‚ πŸ”΄ HIGH RISK (25)                                   β”‚ β”‚
β”‚ β”‚   β”œβ”€ Credit Card Number: 3333-4444...              β”‚ β”‚
β”‚ β”‚   β”œβ”€ Connection String: User ID, Password          β”‚ β”‚
β”‚ β”‚ 🟑 MEDIUM RISK (42)                                 β”‚ β”‚
β”‚ β”‚ 🟒 LOW RISK (15)                                    β”‚ β”‚
β”‚ β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜ β”‚
β”‚ [EXPORT REPORT]                                         β”‚
β”œβ”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”¬β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€
β”‚ πŸ“ FINDING DETAILS   β”‚ πŸ“‹ SCAN LOG                     β”‚
β”‚ (40% vertical space) β”‚ (40% vertical space)            β”‚
β”‚ [Details with        β”‚ [Log messages with              β”‚
β”‚  black border]       β”‚  black border]                  β”‚
β”‚                      β”‚ [Export Log] [Clear Log]        β”‚
β””β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”΄β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”€β”˜

Key UI Features:

  • βœ… Combined file input and scan options into compact header section
  • βœ… Horizontal radio buttons for space efficiency
  • βœ… Results and Details/Log sections use optimal 60:40 vertical split
  • βœ… Side-by-side layout for Finding Details and Scan Log panels
  • βœ… Both detail panels have matching professional black borders
  • βœ… Clean radio buttons without distracting gray backgrounds
  • βœ… Responsive expanding sections that adapt to window size

Enhanced Rule Manager ⭐ New in v1.2.0

The Rule Manager provides a professional interface for managing detection patterns:

Simple Mode Features:

  • βœ… Custom Date Pattern - User-friendly date format converter
    • Input formats: dd/mm/yyyy, mm-dd-yyyy, yyyy.mm.dd, etc.
    • Auto-converts to regex: dd-mm-yyyy β†’ \\b(?:0?[1-9]|[12][0-9]|3[01])-(?:0?[1-9]|1[0-2])-(?:19|20)\\d{2}\\b
    • Supports: dd (day), mm (month), yyyy (4-digit year), yy (2-digit year)
  • βœ… Pre-built Templates - 8 ready-to-use patterns:
    • Email Address
    • Phone Number (US)
    • Credit Card Number
    • IP Address (IPv4)
    • URL
    • Date (MM/DD/YYYY)
    • Date (DD/MM/YYYY)
    • Date (YYYY-MM-DD)
  • βœ… Real-time Testing - Test regex patterns with sample input
  • βœ… Context-aware Help - Helper text adapts to selected pattern type

Advanced Mode Features:

  • βœ… Full regex control - Direct regex pattern editing
  • βœ… Custom categories - Assign patterns to risk categories (HIGH/MEDIUM/LOW)
  • βœ… Whitelisting - Define patterns to exclude from results
  • βœ… Power BI recommendations - Add custom guidance for findings
  • βœ… Full-width fields - Optimized layout for complex patterns

Window & Layout Improvements:

  • βœ… Optimized width - 1035px window width for perfect fit
  • βœ… Fixed panel widths - Current Patterns list maintains 425px
  • βœ… Smart scrolling - Mouse wheel only scrolls panel under cursor
  • βœ… No width jumping - Stable layout when switching pattern types

πŸ’‘ Use Cases

Scenario 1: Pre-LLM Sharing Audit

1. Scan PBIP model before sharing with Claude or ChatGPT
2. Review HIGH risk findings (credentials, PII)
3. Remove/redact sensitive data or use parameters
4. Re-scan to verify all sensitive patterns removed
5. Export final clean report for documentation

Scenario 2: Compliance Review

1. Scan production Power BI models
2. Export detailed findings report
3. Review with compliance/security team
4. Document approved exceptions
5. Implement required RLS or data masking

Scenario 3: Template Sanitization

1. Scan template model before distribution
2. Remove all real data references (SSNs, emails, etc.)
3. Replace with generic examples
4. Update RLS for template users
5. Verify no sensitive patterns remain

Scenario 4: Security Audit

1. Run full scan on all organizational models
2. Filter to HIGH/MEDIUM risk findings
3. Identify models with embedded credentials
4. Move credentials to gateway parameters
5. Configure via Power BI Service gateway settings

πŸ“Š Technical Details

Architecture

sensitivity_scanner/
β”œβ”€β”€ sensitivity_scanner_tool.py       # BaseTool implementation
β”œβ”€β”€ logic/
β”‚   β”œβ”€β”€ models.py                     # Data structures & enums
β”‚   β”œβ”€β”€ pattern_detector.py          # Pattern matching engine
β”‚   β”œβ”€β”€ risk_scorer.py                # Risk assessment & deduplication
β”‚   └── tmdl_scanner.py               # TMDL file scanner
└── ui/
    └── sensitivity_scanner_tab.py    # Compact responsive UI

Pattern Configuration

Patterns are defined in src/data/sensitivity_patterns.json with:

  • Regex patterns for detection
  • Risk level classification
  • Category assignments
  • Example values
  • Whitelist patterns for false positive reduction

Compatibility

  • βœ… PBIP Format: Enhanced report format (PBIR) required
  • βœ… Power BI Desktop: Compatible with latest versions
  • βœ… Windows: Windows 10/11 (64-bit)
  • βœ… Python: 3.8+ (for running from source)

πŸš€ Upgrade Path

From v1.1.1 to v1.2.0

  1. Download the new AE Power BI Multi-Tool.exe (v1.2.0)
  2. Replace your existing executable
  3. No configuration changes required - all existing tools preserved
  4. New Sensitivity Scanner available immediately in tools menu

Breaking Changes

  • ⚠️ None - Fully backward compatible with v1.1.1

πŸ“– Documentation Updates

New Documentation

  • πŸ“š TECHNICAL_GUIDE.md - Comprehensive 2,000+ line guide covering:
    • Architecture overview
    • Pattern detection system
    • Ri...
Read more

v1.1.1 Advanced Copy Updates & Documentation

Choose a tag to compare

@ae-reid-havens ae-reid-havens released this 23 Oct 00:26

πŸš€ AE Power BI Multi-Tool Suite - Version 1.1.1 Release Notes

Release Date: October 20, 2025
Version: v1.1.1 - Advanced Copy Enhancement Edition


🎯 Overview

Version 1.1.1 introduces significant enhancements to the Advanced Copy Tool (formerly "Advanced Page Copy"), expanding its capabilities to handle multiple copying scenarios and introducing a brand new Bookmark + Visual (Popup) Copier feature.


✨ What's New

πŸ”„ Advanced Copy Tool - Major Enhancements

Tool Renamed: Advanced Page Copy β†’ Advanced Copy

The tool has been renamed to better reflect its expanded capabilities beyond simple page copying.

Enhanced Page Copying Capabilities

  • βœ… Multi-page copying: Copy pages 1 or more times in a single operation
  • βœ… Within-PBIP copying: Duplicate pages within the same PBIP file
  • βœ… Cross-PBIP copying: Copy pages between different PBIP files
  • βœ… Complete page preservation: Includes all visuals, themes, and configurations

Advanced Bookmark Management

  • βœ… Bookmark copying: All bookmarks associated with copied pages are duplicated
  • βœ… Bookmark group preservation: Maintains bookmark group structures
  • βœ… Action reassignment: All items with actions pointing to the original page automatically get reassigned to the copied bookmarks
  • βœ… Smart reference updating: Ensures all navigation and interactions work correctly in copied pages

NEW: Bookmark + Visual (Popup) Copier πŸ†•

  • βœ… Popup visual copying: Copy bookmarks along with their associated popup visuals
  • βœ… Within-PBIP support: Duplicate bookmark/popup combinations in the same report
  • βœ… Cross-PBIP support: Copy bookmark/popup combinations between different reports
  • βœ… Complete preservation: Maintains all visual properties, interactions, and configurations

πŸ”§ Bug Fixes

  • πŸ› Fixed action reference issues when copying pages with complex bookmark structures
  • πŸ› Improved bookmark group handling to prevent reference errors
  • πŸ› Enhanced validation for popup visual dependencies
  • πŸ› Resolved edge cases in cross-PBIP bookmark copying

πŸ’‘ Use Cases

Scenario 1: Standardizing Report Templates

Copy a standardized page design multiple times within a report, each with unique bookmarks for different data views.

Scenario 2: Cross-Report Replication

Copy popup bookmarks and their associated visuals from a master template report to multiple client reports.

Scenario 3: Multi-Instance Pages

Create multiple instances of the same page within a report for different user groups, each with properly reassigned actions and bookmarks.


πŸ“Š Technical Details

Architecture Improvements

  • Enhanced bookmark tracking system
  • Improved action reference mapping
  • Optimized visual dependency resolution
  • Better error handling for complex copy operations

Compatibility

  • βœ… PBIP Format: Enhanced report format (PBIR) required
  • βœ… Power BI Desktop: Compatible with latest versions
  • βœ… Windows: Windows 10/11 (64-bit)

πŸš€ Upgrade Path

From v1.0.0 to v1.1.1

  1. Download the new AE Power BI Multi-Tool.exe (v1.1.1)
  2. Replace your existing executable
  3. No configuration changes required - all existing functionality preserved
  4. New features available immediately in the "Advanced Copy" tab

Breaking Changes

  • ⚠️ None - Fully backward compatible with v1.0.0

πŸ“– Updated Documentation

Tool Name Change

  • Old: Advanced Page Copy Tool
  • New: Advanced Copy Tool

Updated Features List

The tool now supports:

  1. Page copying (within/across PBIPs, single/multiple pages)
  2. Bookmark copying (with automatic action reassignment)
  3. Bookmark group preservation
  4. Popup visual copying (new!)

πŸŽ“ How to Use New Features

Multi-Page Copying

  1. Open Advanced Copy tool
  2. Select source PBIP
  3. Select destination PBIP (or same file for within-PBIP copying)
  4. Choose pages to copy (select multiple if needed)
  5. Specify number of copies
  6. Execute - bookmarks and actions automatically reassigned

Bookmark + Popup Copying

  1. Open Advanced Copy tool
  2. Switch to "Bookmark/Popup Copier" mode
  3. Select source and destination PBIPs
  4. Choose bookmarks with associated popups
  5. Execute - maintains all visual properties and interactions

πŸ› Known Issues

  • None currently identified
  • Please report any issues via GitHub Issues

πŸ“ž Support

Need Help?


πŸ™ Acknowledgments

Special thanks to our beta testers and the Power BI community for feedback that helped shape these enhancements.


πŸ“‹ Version History

v1.1.1 - Advanced Copy Enhancement Edition (Current)

  • βœ… Enhanced page copying (multi-page, within/across PBIPs)
  • βœ… Advanced bookmark management with action reassignment
  • βœ… NEW: Bookmark + Visual (Popup) Copier
  • βœ… Tool renamed: Advanced Page Copy β†’ Advanced Copy
  • πŸ› Bug fixes for bookmark references and action mappings

v1.0.0 - Enhanced Report Cleanup Edition

  • βœ… Enhanced Table Column Widths with Fit to Totals defaults
  • βœ… Matrix optimization with hierarchy-aware spacing
  • βœ… Content detection for dates, currency, hierarchy levels
  • βœ… Professional UI with intelligent defaults

v0.0.0 - Beta Version

  • βœ… Multi-tool suite with plugin architecture
  • βœ… Initial release of all core tools

Made with ❀️ and 🧠 AI by Reid Havens for the Power BI professional community

Empowering data professionals with AI-enhanced, enterprise-grade tools for Power BI excellence

v1.0.0

Choose a tag to compare

@ae-reid-havens ae-reid-havens released this 26 Sep 22:10

AE Multi-Tool v1.0.0 - Initial Release

πŸŽ‰ Welcome to the first official release of AE Multi-Tool!

A comprehensive Power BI toolkit designed to streamline report development and optimization workflows.

πŸ†• New Features

Report Cleanup Tool

  • Automated cleanup of Power BI reports and PBIP files
  • Removes unused elements and optimizes report structure
  • Batch processing capabilities for multiple reports
  • Backup creation before cleanup operations

Column Width Tool

  • Standardize column widths across Power BI tables and matrices
  • Bulk width adjustments with customizable settings
  • Visual consistency improvements for professional reports
  • Preserves formatting while optimizing layout

πŸ”§ Core Tools Included

  • PBIP Layout Optimizer - Intelligent positioning and layout optimization
  • Report Merger - Combine multiple reports seamlessly
  • Page Copy Tool - Duplicate pages across reports with ease
  • Report Cleanup - Remove unused elements and optimize structure ⭐ NEW
  • Column Width Standardizer - Consistent table formatting ⭐ NEW

For documentation, examples, and troubleshooting, visit our README

Happy report building! 🎯