skills.rest
wardawgmalvicious
wardawgmalviciousCOMMUNITY
Explore all skills by this author →
GitHub

pbid-tom-live

Automate Power BI Desktop model operations via the msmdsrv.exe Analysis Services proxy using PowerShell.

2|1|Updated May 5, 2026
Search Tags:#performance profiling#PowerShell#DAX#Power BI#model refresh#Analysis Services
One-click install
npx skills add https://github.com/wardawgmalvicious/claude-config --skill pbid-tom-live
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: pbid-tom-live
Source: https://github.com/wardawgmalvicious/claude-config/tree/main/skills/pbid-tom-live
Command: npx skills add https://github.com/wardawgmalvicious/claude-config --skill pbid-tom-live

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires Microsoft.AnalysisServices, Microsoft.AnalysisServices.AdomdClient, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates operations on Power BI Desktop models through their localhost msmdsrv.exe Analysis Services proxy, enabling metadata and DAX query connections from PowerShell.

Core Features & Use Cases

  • Local TOM/ADOMD Connections: Automate metadata and DAX query tasks in Power BI Desktop models using PowerShell.
  • Port Discovery and Connection: Discover and connect to running msmdsrv.exe instances to target specific Power BI Desktop models.
  • DAX Validation and Refresh: Validate DAX expressions before saving and refresh the model using different types of refreshes.
  • VertiPaq DMVs and Query Listener: Access VertiPaq DMVs and use a query listener to capture Visual DAX operations.
  • Performance Profiling: Profile the Formula Engine (FE) and VertiPaq (SE) performance for query optimization.
  • DAXLib UDF Packages: Utilize DAXLib UDF packages for advanced DAX functions.
  • Calendar Column Groups: Create calendar column groups for time intelligence in Power BI Desktop models.
  • Transactions and Rollback: Manage transactions and rollback changes to the model.
  • Source File Path Discovery: Find the source file path for Power BI Desktop models.
  • References and Documentation: Provides extensive references and documentation links for further learning.
  • Use Case: A Power BI developer can use this Skill to automate the process of refreshing a Power BI Desktop model, validate DAX expressions, and profile query performance.

Quick Start

Use the pbid-tom-live skill to refresh the Power BI Desktop model at localhost port 12345.

Frequently Asked Questions about pbid-tom-live

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Power BI Desktop model operations through the localhost Analysis Services proxy?▼

You can automate Power BI Desktop model operations by connecting PowerShell to the localhost msmdsrv.exe Analysis Services proxy, enabling metadata and DAX query connections.

Can I profile Formula Engine and VertiPaq performance for DAX queries in Power BI Desktop?▼

Yes, performance profiling captures Formula Engine and VertiPaq engine performance metrics to help optimize DAX queries running through the Power BI Desktop Analysis Services proxy.

What NuGet packages are required to connect PowerShell to a Power BI Desktop model?▼

You need the Microsoft.AnalysisServices and Microsoft.AnalysisServices.AdomdClient NuGet packages to establish TOM and ADOMD connections for Power BI Desktop model automation.

How do I validate DAX expressions before saving changes to a Power BI Desktop model?▼

DAX validation checks expressions against the connected Power BI Desktop model before saving, ensuring syntax and logic correctness within your active transaction.

Is it possible to discover the msmdsrv.exe port for a running Power BI Desktop instance?▼

Port discovery identifies active msmdsrv.exe instances, allowing you to target specific running Power BI Desktop models and establish local TOM or ADOMD connections.

What are the limitations of refreshing a Power BI Desktop model via the msmdsrv proxy?▼

Model refresh through the msmdsrv proxy requires the Power BI Desktop instance to be actively running, and operations are bound to local model transactions rather than published service datasets.

Related Skills

Explore More Data & Analytics Skills→
rbutinarrbutinar

powerbi-model-edit

Edit Power BI models and validate DAX expressions via the powerbi MCP server.

Community
Advanced
curiositechcuriositech
181

performance-profiling

Analyze Node.js application performance via CPU profiling and database query analysis.

Official
Advanced
edwardpcharlesedwardpcharles
3

dax-optimize

Analyzes VertiPaq timing of Power BI DAX expressions and provides rewrite suggestions with Microsoft Learn documentation.

Community
Advanced
PatrickGallucciPatrickGallucci
16

fabric-pbi-perf-remediate

Diagnose and remediate Power BI performance issues in Fabric environments.

Community
Advanced