Help & Documentation
Open Support Ticket

Connecting to Fabric Data Agent MCP Server: Overview

To enable seamless interaction with the 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 and Copilot

Microsoft Copilot is an AI tool that is very helpful within Microsoft Power BI infrastructure. However, it can't be used outside of it. That's why Fabric Data Agent is used for integration with Concierge. Connection via MCP Server allows interacting with Fabric database 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. Your Fabric can have other Agents set up with different names. These Agents correlate to their respective Domains in Metric Insights Concierge.  A User can ask a financial question and Concierge will know to route that question through the MCP Server to the specific Domain.

Prerequisites

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

  • Microsoft Power BI Administrator account;
  • Azure Administrator account;
  • A set of Permissions for the Azure Fabric App:
    • Item.Execute.All;
    • MLModel.Execute.All;
  • 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

  1. Define the Authentication method: Define how Concierge will perform authentication when connecting to Fabric:
    • "User OAuth": The Token is requested form Fabric and inserted into the configuration code automatically. The User only provides credentials to the service account in Microsoft Power BI. It takes into account the permissions of the User, who makes a query to Concierge. This Auth Type should be used if different users of the Fabric have different levels of access to data and that difference has to be implemented in their Concierge queries.
    • "Inherited from Plugin": The Token will be requested using credentials from the Power BI plugin and then automatically inserted to the configuration code by Metric Insights. This Auth Type should be used if the User also use the Power BI plugin in Metric Insights that has OAuth authentication for connection. Be aware, that Power BI sources set up with Service Principal, Password or Identity Profile authentication method can not be used for External Resource.
  2. Collect data from Power BI account: Locate and copy data for MCP Server setup.
  3. Set up the MCP Server: Run the MCP Server on local machine or remote resource.
  4. Configure Azure Fabric App: Register an App, request Permissions for it and if the "User OAuth" option was chosen for authentication, gather credentials for it.
  5. Configure External Resource in Metric Insights account: Set up Concierge to connect with Fabric Data Agent.