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. 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. Add a custom MCP server
On ChatGPT web, open Plugins, select +, then Add custom MCP server.
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. 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.
- Docs Workload API Spec: Official upstream MCP name: docs_workload-api-spec.
- Docs Platform API Spec: Official upstream MCP name: docs_platform-api-spec.
- Docs Workloads: Official upstream MCP name: docs_workloads.
- OneLake Download File: Official upstream MCP name: onelake_download_file.
- OneLake List Tables: Official upstream MCP name: onelake_list_tables.
- Data Factory Create Dataflow: Official upstream MCP name: datafactory_create-dataflow.
- OneLake Get Table: Official upstream MCP name: onelake_get_table.
- OneLake List Items: Official upstream MCP name: onelake_list_items.
- OneLake List Files: Official upstream MCP name: onelake_list_files.
- OneLake Delete File: Official upstream MCP name: onelake_delete_file.
- OneLake List Table Namespaces: Official upstream MCP name: onelake_list_table_namespaces.
- Data Factory Get Pipeline: Official upstream MCP name: datafactory_get-pipeline.
- Core Create Item: Official upstream MCP name: core_create-item.
- Data Factory List Pipelines: Official upstream MCP name: datafactory_list-pipelines.
- OneLake Create Directory: Official upstream MCP name: onelake_create_directory.
- And 21 more 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.
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.Do I need an API key to connect Fabric to ChatGPT?
No. You sign in to Fabric once through Metorial, and ChatGPT uses that connection. No API keys go into ChatGPT's settings.Which Fabric tools can ChatGPT use?
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.Can I control which teammates use Fabric in ChatGPT?
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.What if ChatGPT doesn't show Fabric tools?
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.
GitHub