How to connect Fabric to ChatGPT

  • ChatGPT gets 36 Fabric tools through one Metorial MCP URL.
  • Setup is 4 steps; teammates then sign in with SSO.
  • You need a ChatGPT plan or workspace that allows custom MCP servers.

What ChatGPT can do with Fabric

Ask your agent in plain language. Each of these maps to a real tool on the server.

  • Ask ChatGPT to use the data factory create dataflow tool in Fabric
  • Ask ChatGPT to use the one lake get table tool in Fabric
  • Ask ChatGPT to use the one lake list items tool in Fabric
  • Ask ChatGPT to use the one lake list files tool in Fabric
  • Ask ChatGPT to use the one lake delete file tool in Fabric

Add the Fabric MCP server to ChatGPT

Run these once. Afterwards, everyone you give access to signs in the same way.

  1. 1. Enable Fabric in Metorial

    In your Metorial portal, enable the Fabric MCP server and sign in with the account that owns the data. Access stays governed by your team policies.

  2. 2. Add a custom MCP server

    On ChatGPT web, open Plugins, select +, then Add custom MCP server.

  3. 3. Paste your Metorial MCP URL

    Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>), choose OAuth and accept the risk notice.

  4. 4. Create and install the plugin

    Select Create as a plugin, install it and sign in to load Fabric tools.

Give your team Fabric in ChatGPT

Once Fabric is enabled in Metorial, teammates sign in with SSO and get the same connection in ChatGPT, with only the tools their role allows.

One link covers every app you approve. See how the MCP gateway handles access, roles and audit logs for the whole company.

Fabric tools available in ChatGPT

Full descriptions and inputs are on the Fabric MCP server page.

Using Fabric tools in ChatGPT

What to expect once Fabric is connected.

  • Type @ and pick the plugin. The selection applies to that message only, so @mention it again when a follow-up needs fresh Fabric data.
  • For write actions, ChatGPT may ask you to confirm first, depending on the app permissions and the action.
  • Once published for a workspace, ChatGPT keeps a snapshot of the tool list. When your team adds Fabric tools in Metorial, an admin refreshes the actions in Workspace settings before they appear.
  • You can use several apps in one prompt, for example read Fabric data and then create a ticket in another app.

Troubleshooting ChatGPT

Add custom MCP server is missing
Workspace policy controls it. On Enterprise and Edu, an admin grants the permission to create plugins with MCPs; ask them to enable it for you.
The plugin exists but no tools appear
Creating the plugin is not enough: install it from your plugins, then start a new conversation so ChatGPT loads its tools.
ChatGPT answers without using the tools
Pick the plugin with @ in the composer and name the action you want, for example "use Metorial to look up the latest ticket".

Based on the ChatGPT MCP documentation.

Frequently asked questions

Common questions about connecting Fabric to AI agents with Metorial.

  1. Does ChatGPT support the Fabric MCP server?
    Yes. ChatGPT connects to the Fabric MCP server through its connector settings, pointed at your Metorial URL. You need a ChatGPT plan or workspace that allows custom MCP servers.
  2. No. You sign in to Fabric once through Metorial, and ChatGPT uses that connection. No API keys go into ChatGPT's settings.
  3. All 36 Fabric tools your team allows, such as Docs Workload API Spec, Docs Platform API Spec, Docs Workloads. Admins can narrow that list per team.
  4. Yes. Role-based access control decides who can use Fabric and which of its tools appear in ChatGPT, and every call is logged with the person's identity.
  5. Workspace policy controls it. On Enterprise and Edu, an admin grants the permission to create plugins with MCPs; ask them to enable it for you.