Set up the Microsoft Fabric MCP server
Microsoft's remote Fabric Core MCP server lets AI agents work with Microsoft Fabric: listing and creating workspaces and items, organizing folders, managing workspace roles, and configuring OneLake shortcuts and data access roles, all under each user's own Fabric permissions. Setup is two steps: register a Microsoft Entra app for OAuth, then install the server from the Mintive (formerly MintMCP) catalog with that app's client ID.
The server is in preview, so Microsoft may change its tools and configuration before general availability.
Prerequisites
- A Mintive admin account
- A Microsoft Fabric tenant with at least one workspace your users can access
- Permission to register applications in your Microsoft Entra tenant
- Users need a role (Viewer, Contributor, Member, or Admin) on the workspaces they will work with
Workspace, folder, and Power BI item tools work on any workspace. Lakehouses, OneLake shortcuts, and other Fabric items need a workspace assigned to a Fabric capacity (trial or paid).
Register a Microsoft Entra app
Microsoft Entra does not support dynamic client registration, so an admin registers an app once and Mintive uses its client ID for the OAuth flow.
-
Sign in to the Microsoft Entra admin center and go to App registrations > New registration.
-
Enter a name, for example
Mintive Fabric. -
Under Supported account types, select Accounts in this organizational directory only (Single tenant).
-
Under Redirect URI (optional), select Public client/native (mobile & desktop) and enter the callback for your Mintive region:
Mintive region Redirect URI US ( app.mintmcp.com)https://app.mintmcp.com/oauth/callbackEU ( eu.mintmcp.com)https://eu.mintmcp.com/oauth/callbackThe install panel in Mintive shows the callback for your organization.
-
Click Register.
-
Go to API permissions > Add a permission > Power BI Service > Delegated permissions, and add:
Permission Grants Workspace.ReadWrite.AllRead and manage the workspaces, folders, and role assignments the user can access Item.ReadWrite.AllRead, create, update, and delete the items the user can access OneLake.ReadWrite.AllRead and manage OneLake shortcuts, data access roles, and settings Capacity.Read.AllList the capacities the user can access Fabric permissions are listed under Power BI Service because both products share one API. For a read-only connector, add
Workspace.Read.All,Item.Read.All, andOneLake.Read.Allinstead of theReadWritepermissions. -
Click Grant admin consent so users are not individually prompted to consent.
-
On the Overview page, copy the Application (client) ID.
Add Microsoft Fabric to Mintive
Microsoft Fabric is listed in the Mintive catalog. Because Entra does not support dynamic client registration, you supply the client ID from the app you registered above.
- In Mintive, go to MCP store > Manage store.
- Find Microsoft Fabric in the catalog and click Install.
- Under OAuth Client Advanced Settings, paste the Application (client) ID in the Client ID field.
- Click Save.
Each user signs in with their own Microsoft account on first use, so every call runs under their identity and their Fabric workspace roles.
Available tools
| Area | Tools |
|---|---|
| Workspaces | list_workspaces, get_workspace, create_workspace, update_workspace, delete_workspace |
| Workspace roles | list_workspace_roles, get_workspace_role, add_workspace_role, update_workspace_role, delete_workspace_role |
| Items | list_items, get_item, get_item_definition, create_item, update_item, update_item_definition, bulk_move_items, delete_item |
| Folders | list_folders, get_folder, create_folder, update_folder, move_folder, delete_folder |
| OneLake shortcuts | onelake_list_shortcuts, onelake_get_shortcut, onelake_create_shortcut, onelake_create_shortcuts_in_bulk, onelake_delete_shortcut, onelake_reset_shortcut_cache |
| OneLake data access roles | onelake_list_data_access_roles, onelake_create_or_update_single_data_access_role, onelake_create_or_update_data_access_roles, onelake_delete_data_access_role |
| OneLake settings | onelake_get_settings, onelake_modify_default_tier, onelake_modify_diagnostics, onelake_modify_immutability_policy |
| Discovery | search_catalog, list_capacities, get_knowledge |
search_catalog searches the OneLake catalog across every workspace the user can access, and get_knowledge returns the item definition format for notebooks, dataflows, lakehouses, reports, and semantic models, which agents need before creating or updating those items.
The server manages Fabric resources but does not query the data inside them. To run DAX against semantic models, add the Power BI MCP server as well.
Security considerations
- Each user authenticates with their own Microsoft account, so calls are bounded by their workspace roles and item permissions in Fabric.
- The client ID alone identifies your Entra app but grants no data access on its own; access always requires a signed-in user and the delegated permissions above.
- Several tools are destructive.
delete_workspacepermanently removes a workspace and everything in it,delete_itempermanently deletes an item, andonelake_create_or_update_data_access_rolesreplaces an item's entire set of data access roles. Disable the tools your team does not need with tool customization, or register the app with the read-only permissions. add_workspace_roleandupdate_workspace_rolelet a workspace admin grant access to other users, groups, and service principals, so treat them like any other permission-granting tool.- All tool calls flow through the Mintive gateway, so they are attributed to individual users in the audit log.
Next steps
- Tool customization: control which Fabric tools are exposed to users
- Set up the Power BI MCP server: query semantic models with DAX
- MCP gateway administration: manage access and permissions across your MCP store