Features

From exploration to governance - natural language tools for every stage.

HOW IT WORKS

All features are exposed as MCP tools that your AI assistant can call. Authoring features support bulk execution, dry-run preview, and transactions.

Feature availability depends on mode (read-only / browse-only) and license tier.

01CORE TOOLS

Core Tools

Essential tools for connecting, browsing, querying, and refreshing Power BI models.

Model Connection

Free

Connect to Power BI Desktop (local) or Power BI Service (XMLA) and manage session context.

CAPABILITIES
  • Discover available models - Find running Power BI Desktop instances
  • Browse Service workspaces - List workspaces you have access to
  • Connect to a model - Establish connection to work with a model
  • Check connection status - See which model is currently connected
  • Sign in/out of Service - Authenticate with Power BI Service

Model Explorer

Free

Model browsing and search across tables, measures, columns, relationships, and more.

CAPABILITIES
  • Browse model objects - List tables, measures, columns, relationships
  • Search by name or expression - Find objects matching your criteria
  • Analyze object details - Get descriptions, previews, column stats
  • View model metadata - Schema info, data sources, compatibility
  • PII maskingPro - Redact sensitive text fields in previews
  • Numeric maskingPro - Mask sensitive numeric values in previews

DAX Query Runner

Free

DAX execution and diagnostics with row-capped results and performance metrics.

CAPABILITIES
  • Execute DAX queries - Run queries and get tabular results
  • Basic query timing - Execution time and row counts
  • Query plans & detailed timingsPro - Engine breakdown and optimization hints
  • Query tracingPro - Capture detailed execution trace
  • View VertiPaq statistics - Storage engine compression and memory

Data Refresh

Free

Refresh at Partition, Table, or Model scope with type control.

CAPABILITIES
  • Full refresh - Complete data reload from source
  • Data-only refresh - Reload data without recalculating
  • Calculate refresh - Recalculate without reloading data
  • Check refresh status - Query current refresh state

02AUTHORING TOOLS

Authoring Tools

Full-mode tools for creating and modifying semantic model objects.

Semantic Layer

BulkDry-runFree

Semantic layer authoring for measures, KPIs, calculation groups, UDFs, and named expressions.

CAPABILITIES
  • Create & edit measures - Add DAX calculations to your model
  • Manage KPIs - Define targets, status, and trends
  • Build calculation groups - Reusable calculation logic (time intel, currency)
  • Define user functions - Create reusable DAX functions
  • Named expressions - Shared M or DAX expressions
  • Transaction recordingPro - Track changes for history/diff/rollback

Schema Manager

BulkDry-runFree

Schema authoring for tables, partitions, columns, relationships, hierarchies, and calendars.

CAPABILITIES
  • Create & modify tables - Add or update table definitions
  • Manage partitions - M, SQL, DAX, or Entity partitions
  • Add calculated columns - Row-by-row DAX calculations
  • Define relationships - Connect tables with proper cardinality
  • Build hierarchies - Create drill-down paths

Security Manager

BulkDry-runFree

Roles (RLS/OLS) and perspectives management for access control.

CAPABILITIES
  • Create security roles - Define RLS and OLS roles
  • Set row-level filters - DAX filters to restrict data access
  • Configure permissions - Read, process, admin rights per role
  • Manage perspectives - Simplified views for different audiences
  • Transaction recordingPro - Track changes for history/diff/rollback

Localization

BulkDry-runFree

Cultures and translations for multi-language model support.

CAPABILITIES
  • Add language cultures - Support 40+ regional formats
  • Translate labels - Localize table, column, measure names
  • Manage translations - Update or remove existing translations

Model Properties

Free

Global model properties including description, culture, annotations, and compatibility level.

CAPABILITIES
  • View model settings - Current configuration and metadata
  • Update properties - Description, default culture, annotations

03GOVERNANCE TOOLS

Governance Tools

Tools for preferences, policies, and license management.

Preferences Memory

Free

Portable preferences memory for naming rules, guardrails, aliases, and default behaviors.

CAPABILITIES
  • Store naming conventions - Remember your preferred patterns (5 max in Free)
  • Define guardrails - Set constraints the AI should follow
  • Create aliases - Shortcuts for common operations
  • Unlimited preferencesPro - No quota on stored preferences
  • Model-specific preferencesPro - Different settings per model
  • Export/import preferences - Share settings across projects

Policy Engine

Pro

Policy guardrails for tool execution with allow/deny/confirm rules.

CAPABILITIES
  • Define allow/deny rules - Control which operations are permitted
  • Require confirmations - Add approval steps for risky actions
  • Use policy recipes - Pre-built policy templates
  • Validate before apply - Check policies without committing
  • Policy enforcement - Actively enforce rules during execution

License Manager

Free

License lifecycle management for activation and status checking.

CAPABILITIES
  • Check license status - Current tier, expiry, features
  • Activate license - Apply a new license key
  • Refresh license - Renew online lease tokens
  • Deactivate license - Release for use on another machine

04PRO & ENTERPRISE TOOLS

Pro & Enterprise Tools

Advanced tools for change management, testing, and compliance.

Impact Analyzer

Pro

One change can break everything. See exactly what depends on any measure or column before you touch it.

CAPABILITIES
  • Direct dependency lookup - Find what immediately references an object
  • Transitive traversal - Trace cascading impacts 1-4 levels deep
  • Export to Mermaid - Generate visual flowcharts and mindmaps
  • Export to DOT/CSV - Graph format and tabular exports

Version Control

Pro

AI models make mistakes. Version control lets you undo them instantly with history, diffs, and one-click rollback.

CAPABILITIES
  • View change history - See all modifications to the model
  • Compare versions - Diff between any two points in time
  • Rollback changes - Undo to a previous state
  • Create checkpoints - Named snapshots you can restore
  • Build changesets - Group related changes together
  • Preview before apply - See exactly what will change

Test Runner

Pro

Validate your model before deployment. Define expected values, run test suites, and export results for CI/CD pipelines.

CAPABILITIES
  • Define test cases - Expected values for measures and queries
  • Run test suites - Execute all tests and get results
  • Set baselines - Capture known-good values
  • Export test reports - Share results with stakeholders
  • Package test packs - Bundle tests for CI/CD pipelines

Audit Log

Enterprise

Tamper-evident audit log management. Tool visibility can be disabled unless explicitly enabled.

CAPABILITIES
  • View audit log - All operations with timestamps and users
  • Export for compliance - Generate reports for auditors
  • Verify log integrity - Cryptographic tamper detection
  • Rotate audit keys - Refresh signing keys periodically

05 — SEMANTIC MODEL COVERAGE

Semantic Model Coverage

Query and manage all Power BI object types with full semantic model support.

15 Queryable Object Types

Full semantic model coverage
Measures
DAX calculations & aggregations
KPIs
Key performance indicators
Calculation Groups
Reusable calculation logic
UDFs
User-defined functions
Tables
Data tables & fact tables
Columns
Fields & calculated columns
Partitions
M/SQL/DAX/Entity partitions
Relationships
Table connections & cardinality
Hierarchies
Drill-down structures
RLS Roles
Row-level security filters
OLS Roles
Object-level security
Perspectives
Filtered model views
Cultures
40+ regional formats
Translations
Multi-language labels
VertiPaq Stats
Compression & memory analysis

Ready to get started?

Install MCP Engine in seconds and start using natural language to work with your Power BI models.