semantic-model-consumption

Execute DAX queries and inspect metadata of Power BI semantic models via MCP tools.

Updated Jul 14, 2026
One-click install
npx skills add https://github.com/9vantage/skills-for-fabric-clone --skill semantic-model-consumption-9vantage
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: semantic-model-consumption
Source: https://github.com/9vantage/skills-for-fabric-clone/tree/main/plugins/fabric-skills/skills/semantic-model-consumption
Command: npx skills add https://github.com/9vantage/skills-for-fabric-clone --skill semantic-model-consumption-9vantage

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Analysts working with Microsoft Fabric Power BI semantic models need a reliable way to run raw DAX queries and explore model metadata (tables, columns, measures, relationships) without authoring or modifying the model itself. ## Core Features & Use Cases - DAX Query Execution: Run EVALUATE statements against a semantic model through the FabricIQ MCP server ExecuteQuery tool, with support for up to 4 queries per call and row limits. - Metadata Discovery: Inspect model structure using INFO.VIEW.* and INFO.* DAX functions, with a recommended discovery order, scope estimation queries, and projection/filtering patterns to control output volume. - Dependency Analysis: Trace measure dependencies and reverse dependencies using INFO.DEPENDENCIES for impact analysis. - Use Case: Given a workspace and semantic model name, resolve the model's artifact ID, list its tables and measures, then run a SUMMARIZECOLUMNS query to answer a business question. ## Quick Start Ask the assistant to run a DAX query such as EVALUATE INFO.VIEW.TABLES() against a named Power BI semantic model in your Fabric workspace.

Frequently Asked Questions about semantic-model-consumption

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

FAQPage Schema
How do I run a DAX query against a Power BI semantic model in Fabric?

Call the ExecuteQuery MCP tool with the semantic model's artifactId and an array of 1-4 DAX queries, each containing a single EVALUATE statement. Find the artifactId first using the DiscoverArtifacts MCP tool with the model name.

How do I list tables, columns, and measures in a semantic model?

Use DAX INFO.VIEW functions: INFO.VIEW.TABLES() for tables, INFO.VIEW.COLUMNS() for columns, INFO.VIEW.MEASURES() for measures, and INFO.VIEW.RELATIONSHIPS() for relationships. Narrow results with SELECTCOLUMNS and FILTER to reduce output volume.

What is the difference between INFO.VIEW.* and INFO.* DAX functions?

INFO.VIEW.* functions are available to any user with read access and are preferred for first-pass metadata discovery. Many INFO.* functions expose deeper diagnostics and storage internals but may require elevated semantic model permissions.

Why does ExecuteQuery fail or appear unavailable in the MCP server?

The FabricIQ MCP server may not be registered, not loaded, or the client session has stale tool metadata. Verify the active MCP server and tool inventory and confirm ExecuteQuery is exposed before retrying.

Can this skill create or modify semantic model definitions?

No. This skill is strictly read-only, limited to metadata discovery and analytical DAX queries. For creating, deploying, or managing semantic model definitions, use the semantic-model-authoring skill instead.

Why does INFO.ROLEMEMBERSHIPS return empty results?

Role members are assigned at the service level through Entra ID after deployment, not stored in the model definition, so DAX INFO functions cannot reliably surface them. Use the Fabric service role membership management documentation instead.