Microsoft Fabric MCP server: ask questions, get governed answers
Microsoft Fabric is a Microsoft analytics platform that combines lakehouses, data warehouses and Power BI semantic models, holding an organization's curated analytical and reporting data.
Try it on your own data in a pilot.
Microsoft Fabric AI analytics: what you can ask
Typical questions from data and BI teams. Each answer shows the definition, source and query behind it.
- What was monthly revenue by business unit in the sales lakehouse this year?
- Which 10 products have the highest gross margin in the warehouse?
- Compare this quarter's sales to last quarter by region
- List semantic model tables that haven't refreshed in the last 7 days
- How has weekly active customer count trended over the past year?
How Nexatron connects to Microsoft Fabric
- Whose permissions
- Your administrator approves the access the Microsoft Fabric connection uses. Where Microsoft Fabric supports per-user sign-in, answers run under each person's own access, and Nexatron roles decide who in your company can ask.
- Read and write
- Questions are read-only: asking never changes Microsoft Fabric data.
- Setup
- Our team sets up the Microsoft Fabric connection with your administrator during the pilot. No data migration and no pipeline to build: data is queried where it lives.
Microsoft Fabric MCP connector for Claude, ChatGPT and Copilot
Nexatron's hosted MCP server is a governed Microsoft Fabric MCP connector: Claude, ChatGPT and Microsoft Copilot ask questions of your Microsoft Fabric data through it. Each person signs in as themselves, so the assistant sees only what they may see.
Connect Microsoft Fabric to Claude, ChatGPT or Copilot
- Connect Microsoft Fabric to your Nexatron workspace.
- In Claude, add Nexatron from Claude's connector directory. In ChatGPT or Copilot, add a custom MCP connector with the server URL
https://api.nexatron.io/api/v1/mcp. - Sign in with your own Nexatron identity (OAuth 2.1), then ask your Microsoft Fabric questions.
Microsoft Fabric connector FAQ
- Can I ask Microsoft Fabric questions without writing queries?
- Yes. Ask in Teams, Slack, the Nexatron web app, or an AI assistant connected through Nexatron's MCP server.
- Does Nexatron respect Microsoft Fabric permissions?
- Yes. Where Microsoft Fabric supports per-user sign-in, answers run under each person's own access.
- Can Nexatron change data in Microsoft Fabric?
- No. Asking a question never changes Microsoft Fabric data.
- What do I need to connect Microsoft Fabric?
- An administrator who can approve the connection. Our team sets it up with them during the pilot.
- Is there a Microsoft Fabric MCP server for Claude, ChatGPT or Copilot?
- Yes: Nexatron's hosted MCP server, once Microsoft Fabric is connected to your workspace. It is Nexatron's server, not one published by Microsoft Fabric, and the assistant gets the same governed answer as the Nexatron app.
Try Nexatron on your own Microsoft Fabric data
A pilot starts with three questions your team already asks and the report you trust for each, so you can check the answers yourself.
Microsoft Fabric is a trademark of its owner. Nexatron is not affiliated with or endorsed by it; the name and mark identify the system Nexatron connects to.