MCP App Store
by KeenEthics
Microsoft Fabric IQ icon

Microsoft Fabric IQ MCP Server for ChatGPT

By Microsoft

Overview

Microsoft Fabric IQ finds the Power BI reports and semantic models you can access in Microsoft Fabric, reads their tables, measures and relationships, writes and runs the DAX query for you, and explains the result in plain language. It runs with your own delegated permissions, respects row-level and object-level security, and is read-only: it never creates, changes or deletes reports, models or measures.

How to connect

  1. ChatGPT: Open the Microsoft Fabric IQ listing in the ChatGPT app directory and choose Connect. ChatGPT listing Microsoft Fabric IQ exposes 6 tools here.

Tools

DiscoverArtifacts

ChatGPT
Searches for Power BI artifacts (Semantic Models and Reports) based on search text. Provides details about matching artifacts including their name, artifact ID, artifact type, direct access link, workspace name, and description. Use this tool to find Semantic Models and Reports across your Power BI tenant.

ExecuteQuery

ChatGPT
Executes a DAX query and return the results. The results should be used to answer the user's data question.

GetReportMetadata

ChatGPT
Retrieves the schema of a Power BI report, including workspace information, semantic model details, pages, visual information, and filters. Use this tool when you need to resolve ambiguities about which tables, columns, or measures are most relevant to the user's request, or when you need to understand what filters should be applied. Reports reveal how the semantic model is actually used in practice and can clarify the intended context, relationships, and filtering logic that should guide your DAX query generation. Always consult report schemas when there are multiple possible interpretations of the user's requirements. With queries, executes JMESPath expressions and returns matching results. Otherwise returns the full schema, or an overview if the report is large.

GetSemanticModelSchema

ChatGPT
This tool retrieves comprehensive metadata for a specified semantic model, including the serialized schema, custom instructions provided by the model author, and verified answers when available. The schema can be used to understand the structure and relationships in the data model. Custom instructions guide which context is relevant to user questions. Verified answers provide pre-built questions and visualizations that demonstrate what insights can be derived from the data. With queries, executes JMESPath expressions and returns matching results. Otherwise returns the full schema, or an overview if the model is large.

ResolveFabricItem

ChatGPT
Resolves a Fabric or Power BI item to its canonical identity. Accepts either a bare item GUID (preferred) or a supported artifact URL, and returns the canonical fabricItemId, itemType, workspaceId when known, and optional next-step instructions.

ValueSearch

ChatGPT
Resolves entity names and filter values to exact table/column/value locations in a semantic model's pre-built index. Call this before generating DAX when the user's question mentions specific names, categories, or filter values — without it, DAX filters may target wrong columns or use incorrect casing. Skip only for purely aggregate or structural queries. Returns match Score per result (1.0 = exact). When a value matches multiple tables, use Score and question context to pick the correct one. Use the resolved table, column, and value matches when constructing DAX filters.

Capabilities

Find Power Bi Reports And Semantic ModelsRead Report And Semantic Model MetadataRun Read-Only Dax Queries

Example Prompts

Click any prompt to copy it.

Similar Apps

Listed on MCP App Store

Listed on MCP App Store

Add this badge to your site or README. It links to this page.

HTML

<a href="https://mcp-app-store.keenethics-labs.com/app/microsoft-fabric-iq"><img src="https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg" alt="Listed on MCP App Store" width="220" height="44"></a>

Markdown

[![Listed on MCP App Store](https://mcp-app-store.keenethics-labs.com/badges/listed-on-mcp-app-store.svg)](https://mcp-app-store.keenethics-labs.com/app/microsoft-fabric-iq)