100% Client-Side Privacy-First Architecture

The Ultimate Diagnostics Utility for Power BI, Built for the Web

Optimize data models, clean up unused columns, document custom visual containers, and format DAX expressions. All processed locally in your browser—no file size limits, zero server uploads.

PBIX / PBIT Parser

Drag & drop layout files to inspect canvas metadata, query lists, visible/hidden page counts, and export responsive PDF/JSON audit catalogs.

Performance Auditor

Extract unused visual fields, scan auto date-time tables, analyze column cardinality levels, and review structured model optimization logs.

DAX Formatter & Linter

Format, capitalize, and structure complex DAX measures. Check syntax logic for DIVIDE errors and filter performance sinks instantly.

Side-by-Side Diff Compare

Inspect structural adjustments between two report revisions. Track canvas dimensions changes, visual modifications, and page edits.

🔒 Corporate Compliance & Security Guaranteed

Power BI Helper Online leverages client-side unzipping via in-memory workers. Your data files never leave your workstation. We do not use databases, analytics tracking, or external server APIs for file handling.

Upload your Power BI File

Select or drag & drop any .pbix or .pbit file below

Entire processing runs locally in browser. No file size restrictions.

Extracting Report Packages...

Decompressing archive and cataloging schema tables...

Report.pbix

0 MB

Parser Views

Overview Dashboard

Visual Layout Map

Visual Elements List

Field References

PBIX Archive Overview

Total Pages

Visual Objects

Report Bookmarks

Custom Visuals

Archive File Trees

Canvas Size & Config

The `Layout` schema defines the configuration state of client canvases, visual elements containers, grids, custom styles, and connections.

Interactive Visual Layout Map

Click on report pages to render their visual boundary maps and positioning

Selected Page Resolution: 1280 x 720 (16:9)

Catalog of Visualization Containers

Page Name	Visual Type	Container Title	Dimensions (W x H)	Position (X, Y)

Visualization Field Bindings & References

Extracts column and measure reference arrays declared inside report visual query containers

Source Table	Referenced Field / Measure	Used on Report Pages

Report Model Not Loaded

To run performance tuning analysis, scan column cardinality levels, and audit unused fields, please load a PBIX file first.

Data Model Optimization Workspace

Automated heuristics scan reports against SQLBI and Microsoft model design guidelines

Model Grade

Score: 92/100

Optimization Review Summary

Our client-side rules engine checked model relationships configuration, metadata naming sizes, date tables, and visualization query mappings. Follow the diagnostic instructions below to clean up model schemas and reduce final file sizes.

🔥 Clean Columns

Fields actively mapped in visualizations

⚠️ Unused Candidates

Unreferenced table fields (ready for cleanup)

Automated Diagnostic Checks

Data Model Cleanup Recommendations

The following fields are defined in layout metadata blocks but are **never referenced** in visualizations, report-level filters, custom visual buckets, or bookmarks. Removing unused fields reduces dictionary file sizes and optimizes memory load times.

Table Name	Unused Candidate Name	Cleanup Impact	Recommended Action

DAX Query Studio & Linter

Format nested measures, capitalize operations, and check query syntax against SQLBI design rules

MEASURE DEFINITION

1
2
3
4
5
6
7
8
9
10

DAX Heuristic Auditor

Linter Ready

Paste your DAX expression and press Format to inspect optimization advice.

Formatted rules include: Line splits on operators, capitalisation alignment for core DAX calls (e.g. CALCULATE, VALUES, FILTER, SUMX, CALCULATETABLE), indents on function parentheses, and VAR/RETURN structural blocks splitting.

Side-by-Side Version Comparator

Load two PBIX report versions side-by-side to cross-examine adjustments made on page grids, canvas configurations, and visual inventories

File A (Original Version)

Select or drop file

File B (Modified Version)

Select or drop file

Version Comparison Log

File A vs File B

File A Pages

File B Pages

File A Visuals

File B Visuals

Page Adjustments Log

Visual Adjustments Log

Power BI Service Sync & Tenant Explorer

Securely sync and generate report logs for cloud workspaces, dataflows, datasets, and gateways

Mock Tenant Workspaces

Tenant Offline

API Integration & Guide

Connecting Power BI Service directly from standard client-side static web apps requires establishing OAuth credentials via Microsoft Entra ID. Below is our step-by-step developer tutorial for registering applications and orchestrating sync protocols.

Registering an Azure Active Directory App

Log in to the **Microsoft Entra admin center** (Azure portal) using Tenant administrator credentials.
Navigate to **App registrations** > **New registration**.
Input a name (e.g. PowerBIHelperOnline) and specify **Supported account types** (typically *Single tenant*).
Set the Redirect URI to a secure local/web host (e.g. `https://yourdomain.com/auth-callback`).
Click **Register**. Store the generated **Application (client) ID** and **Directory (tenant) ID** values securely.
Navigate to **API permissions** > **Add a permission** > **Power BI Service**.
Enable administrative delegate permissions such as:
- Tenant.Read.All or Tenant.ReadWrite.All
- Workspace.Read.All
- Report.Read.All
Grant admin consent for the selected permission blocks.

PowerShell Automation Script

Execute the following automated PowerShell command list to fetch workspace datasets catalog properties directly into standard JSON dumps:

# 1. Install Microsoft Power BI Cmdlets
Install-Module -Name MicrosoftPowerBIMgmt -Scope CurrentUser

# 2. Authenticate to the Power BI Tenant
Connect-PowerBIServiceAccount

# 3. Retrieve and Export Workspace Metadata Log
$workspaces = Get-PowerBIWorkspace -All
$workspaces | ConvertTo-Json -Depth 5 | Out-File ".\PBILogs.json"

# 4. Success Alert
Write-Host "Metadata Export Completed successfully!" -ForegroundColor Green