--- title: "Microsoft Fabric Integration for Rig: Query Microsoft Fabric Data in Plain English" description: "Connect Microsoft Fabric to Rig and query your Microsoft Fabric data in plain English, or ask it in Claude, ChatGPT and Cursor. Governed, validated answers from your warehouse." canonical: "https://rig.so/integrations/microsoft-fabric" format: markdown --- Browse integrations ![Microsoft Fabric logo](https://img.logo.dev/fabric.microsoft.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=112&format=png&retina=true) Warehouses & databases Supported # Microsoft Fabric integration for Rig ## The easiest way to query Microsoft Fabric in Claude and other AI tools Microsoft Fabric is Microsoft's analytics platform, and its Warehouse and Lakehouse SQL analytics endpoint expose tables over a SQL connection. [Try Rig](https://app.rig.so/signup)[Book a demo](https://rig.so/book-demo) ## What Rig sees in Microsoft Fabric Once connected, Rig models these objects so questions resolve to the right tables and joins: - Tables in the schema you choose - Warehouse tables - Lakehouse tables through the SQL analytics endpoint ## How Microsoft Fabric connects to Rig Rig Ingest signs in to your Fabric SQL endpoint as a Microsoft Entra service principal with Viewer access or above on the workspace, and syncs the tables you choose into your warehouse on a schedule. [Read the step-by-step Microsoft Fabric setup guide](https://rig.so/guides/connect-microsoft-fabric) ## Combine Fabric tables with your other sources Fabric often holds data landed from finance, operations or ERP systems. Rig copies the tables you select into your warehouse, so they can be joined to CRM, billing and marketing data. Ask Rig - Which tables are synced from Fabric, and how many rows does each hold? - Join Fabric orders to CRM accounts - How current is each Fabric table? ## Let AI tools query Fabric data Fabric tables synced into your warehouse become available to Rig's governed SQL. Claude, ChatGPT and Cursor can then answer questions over them through MCP. Ask Rig - Summarise the tables in the Fabric schema - What columns does a given Fabric table have? - Show row counts by table ## Read a Lakehouse through its SQL endpoint A Lakehouse exposes its tables through a SQL analytics endpoint. Rig connects to that endpoint with the same service principal, so Lakehouse and Warehouse tables can be synced the same way. Ask Rig - Which Lakehouse tables are available to sync? - Show the newest rows in a Lakehouse table - Compare a Lakehouse table with its Warehouse copy ## Ask your Microsoft Fabric data in Claude, ChatGPT or Cursor Rig serves your Microsoft Fabric data to AI assistants over MCP. Once Microsoft Fabric is synced into your warehouse, you can ask questions in plain English from the tool you already use, and every answer is backed by validated, governed SQL. - [Claude](https://rig.so/integrations/claude) - [Claude Code](https://rig.so/integrations/claude-code) - [Cursor](https://rig.so/integrations/cursor) - [ChatGPT](https://rig.so/integrations/chatgpt) - [Codex](https://rig.so/integrations/codex) - [Gemini](https://rig.so/integrations/gemini) ## Frequently asked questions How does Rig sign in to Fabric? With an Entra service principal: a tenant ID, an application (client) ID and a client secret. Fabric does not support SQL authentication on this endpoint. What access does the service principal need? Workspace access at Viewer or above. You can also grant SELECT on specific tables to restrict what it reads. Which Fabric items work? A Warehouse, or a Lakehouse through its SQL analytics endpoint. Which port and network access does it use? Fabric's SQL connection string uses TCP port 1433, so allow that traffic through any firewall you run. ## Related integrations [![Amazon Redshift logo](https://img.logo.dev/aws.amazon.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)Amazon RedshiftPlain-English analytics over your Redshift cluster, governed and validated.](https://rig.so/integrations/redshift)[![BigQuery logo](https://img.logo.dev/cloud.google.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)BigQueryAsk questions of your BigQuery datasets from Claude, ChatGPT or Cursor.](https://rig.so/integrations/bigquery)[![BigQuery shared datasets logo](https://img.logo.dev/cloud.google.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)BigQuery shared datasetsMirror a BigQuery dataset a vendor or partner has shared with you.](https://rig.so/integrations/bigquery-dataset)[![Databricks logo](https://img.logo.dev/databricks.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)DatabricksQuery your Databricks lakehouse in plain English from any AI tool.](https://rig.so/integrations/databricks)[![Microsoft SQL Server logo](https://img.logo.dev/microsoft.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)Microsoft SQL ServerPlain-English questions over SQL Server and Azure SQL, governed by Rig.](https://rig.so/integrations/sql-server)[![MongoDB logo](https://img.logo.dev/mongodb.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)MongoDBMirror MongoDB and Atlas collections into your warehouse.](https://rig.so/integrations/mongodb) ## Connect Microsoft Fabric data to AI tools like Claude Rig builds a governed context layer over your data so every team, and every AI tool, asks questions and gets answers they can trust. [Try Rig](https://app.rig.so/signup)[Book a demo](https://rig.so/book-demo) --- - [This page as HTML](https://rig.so/integrations/microsoft-fabric) - [Site map for language models](https://rig.so/llms.txt) - [API and agent documentation](https://rig.so/developers)