Help & Documentation
Open Support Ticket

Connecting to Microsoft Fabric Data Agent MCP Server: Overview

To enable seamless interaction with the Microsoft Fabric Data Agent AI tool directly from Concierge, Metric Insights supports integration through a Model Context Protocol (MCP) Server. This connection provides Users with access to Fabric’s Conversational Analytics and other AI-powered capabilities, allowing them to ask natural-language questions about their data from within Concierge — without switching platforms.

Difference Between Fabric Data Agents and Copilot

Microsoft Copilot is an AI tool that is available within the Microsoft Power BI infrastructure. However, it can not be used outside of Power BI. That is why Fabric Data Agents are used for integration with Concierge. Connection via MCP Server allows interacting with your data through Fabric Data Agents from the Concierge service.

Architectural Diagram for Fabric MCP Server Integration with Concierge

This diagram shows an example, where Microsoft Fabric was configured to have Financial Data and Sales Data as Data Agents. Each Agent is associated with a Domain in Metric Insights Concierge.  When a user asks a financial question, Concierge uses domain metadata to route that question through the MCP Server to the relevant Fabric Data Agent.

Prerequisites

To perform all the steps necessary for connecting Concierge and Fabric, you need the following:

  • Microsoft Power BI Administrator account;
  • Azure Administrator account;
  • The Item.Execute.All permission for the Azure Fabric App;
  • Server space for MCP Server. The required specs:
    • Python 3.12 or higher;
    • 256MB RAM and 1 vCPU;
    • Required Python packages (see requirements.txt in git repository).
  • Metric Insights Administrator account.

Steps to Connect Concierge and Fabric Data Agent

Before starting, decide how Concierge will perform authentication when connecting to Fabric.  Metric Insights supports per user authentication to Microsoft Fabric. This preserves user level identity for enforcing row level security.  This can be done one of two ways:

  • Inherited from Plugin: If there is already a Metric Insights Data Source connecting to Power BI via OAuth, this data source can be reused for connecting Concierge to Microsoft Fabric. The Fabric Application used in that connection will need to have Power BI Service: Item.Execute.All delegated permission. For more information about that, check this documentation.
  • User OAuth: Use this method to create a new connection to the Fabric Application used for the Fabric Data Agent(s).

Besides that, create one or several Data Agents.

  1. Collect data and configure PowerBI account: Locate and copy data for MCP Server setup.
    • Add users to the Workspace: Decide how you will be adding users to the Workspace:
      • Each user separately. This can be done in the PowerBI account.
      • Create a user group in Azure. After that it will be possible to add a whole group in PowerBI account.
  2. Set up the Metric Insights MCP Server for Fabric: Install and run the Metric Insights MCP Server for Fabric on a local machine or as a remote resource.
  3. Configure Azure Fabric App: Register an App, request the required Permission, and, if using "User OAuth" for authentication, gather the credentials.
  4. Configure an External Resource in Metric Insights: Set up Concierge to connect to the Fabric Data Agent.