Start free
Files, notes and calendars

Microsoft Fabric MCP server

Through Flowplane an AI assistant uses Microsoft’s Fabric Core MCP server to look after your Fabric estate: search items across workspaces, list and create workspaces, create and change items such as lakehouses, notebooks, pipelines and semantic models, and see or change who has a role in a workspace. It is for managing resources, not for querying the data in your tables. Reads go straight through; every change, role grant and deletion waits for your approval by default.

Connect Microsoft Fabric →Set up your assistant
Tools
The app’s own set
Sign-in
Your own account
Approval, by default
Changes wait for you
MCP server
The app’s, passed through
What it can do

What your assistant can do in Microsoft Fabric

Flowplane passes Microsoft Fabric’s own MCP server through, so the tools are the ones Microsoft Fabric offers when you connect. By default reads are allowed and anything that changes something waits for the person’s approval; your workspace’s rules decide.

Reads allowed

Looking things up runs straight away, within what the account you connected may see.

Changes asks first

Creating, changing or deleting waits for your approval in the browser, unless your workspace’s rules say otherwise.

How it connects

Sign-in

Each person signs in with their own Microsoft work or school account, and the assistant acts as them: it sees and may do only what their Fabric permissions allow. Fabric has to be on for your organisation, and the first sign-in may ask a Microsoft administrator to approve Flowplane once. Flowplane keeps the login sealed; the assistant never sees it.

In Flowplane: In the Flowplane console, add Microsoft Fabric and sign in with Microsoft. There is nothing to fill in.

MCP

Microsoft Fabric and MCP

Microsoft runs an official remote MCP server for Fabric, Fabric Core MCP Server. Flowplane passes it through as it is and adds its own approvals on top, so there is nothing to install or register.

Try it

Things to ask

  • “List all my Fabric workspaces.”
  • “Find the lakehouses with “Customer” in their name.”
  • “Who has Admin access to the Sales Analytics workspace?”
  • “Create a workspace called Finance Dev with a lakehouse named Ledger.”
  • “Add an.peeters@example.be as Contributor to the Finance Dev workspace.”
Your assistant

Connect your assistant to Microsoft Fabric

One Flowplane address works in every assistant below, with the same rules and the same log. Step-by-step setup for each:

FAQ

Questions

Can the assistant change who has access?
Yes, Microsoft’s server can grant and revoke workspace roles. Flowplane treats that as a change like any other: it waits for your approval by default, as do creating, changing and deleting workspaces and items.
Can it read or query the data in a lakehouse or semantic model?
No. This server manages workspaces, items and roles. To ask questions of Power BI reports and semantic models, add Microsoft Fabric IQ.
Which AI assistants can use Microsoft Fabric through Flowplane?
Claude, Claude Code, ChatGPT, Cursor, Codex, GitHub Copilot and Mistral Le Chat, and any other client that supports remote MCP servers with sign-in. They all reach Microsoft Fabric through the same Flowplane address.
What does it cost?
Free for one person, with up to three apps and five assistants. Personal Pro is €9 a month including VAT; companies start at €99 a month for ten active users. Prices are indicative; see the pricing page.

Flowplane is not affiliated with or endorsed by Microsoft Fabric’s maker; the name and logo only identify the app. Pricing

Let your AI work with your data. Safely, from today.

Free for yourself, set up in a minute. For your team or company, we’re happy to help you get started.

Start free →Book a call