pbid-tom-live

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.