Skip to content
ajan.io

Docs menu

On this page

Microsoft Fabric

Connect Microsoft Fabric to ajan to ask questions about data exposed through APIs for GraphQL and run mutations.

Overview

Use the Microsoft Fabric integration to ask questions about business data in ajan. ajan can find accessible APIs for GraphQL, inspect the required schema, and run focused queries. Write requests use a separate mutation action with confirmation before execution.

Use Microsoft Fabric

  1. Open Microsoft Fabric in ajan, select Add connection, and sign in with your Microsoft account.
  2. Tag Microsoft Fabric in a chat.
  3. Ask a question about your data. Name the workspace or GraphQL API only when ajan asks you to distinguish between multiple matches.

Supported data

A GraphQL API can expose and combine selected objects from these supported sources:

  • Microsoft Fabric Data Warehouse
  • Microsoft Fabric SQL database
  • Microsoft Fabric Lakehouse through its SQL analytics endpoint
  • Microsoft Fabric mirrored databases through their SQL analytics endpoints, including:
    • Azure SQL Database
    • Azure SQL Managed Instance
    • Azure Cosmos DB
    • Microsoft Fabric SQL database
    • Azure Databricks
    • Snowflake
    • Open mirrored databases
  • Azure SQL Database connected directly

Microsoft Fabric Data Warehouses and Fabric SQL databases support queries and can expose mutations. Their stored procedures, as well as those from directly connected Azure SQL databases, can be exposed as controlled write operations. SQL analytics endpoints provide query access. See Microsoft's supported data sources and features for the current source matrix and current GraphQL limitations.

ajan uses an API for GraphQL item as the governed access layer across these sources. You choose in Fabric which objects and operations to expose, while specialized workloads such as Eventhouses, notebooks, pipelines, and semantic models continue to use their dedicated interfaces and integrations.

Large results and exports

Ask for focused fields, filters, aggregation, and smaller pages whenever possible. ajan returns larger successful query results as a JSON file automatically. You can also ask for a JSON file explicitly when you need a complete export for a workflow or code environment.

If a result is too large to return, narrow the query or retrieve it in multiple pages. For mutations, verify the changed record in Fabric before deciding whether to repeat an operation whose response could not be returned.

Choose the guide you need

  • Admin configuration — Prepare and secure a Fabric API for GraphQL, then configure the integration for your workspace.
  • Access and mutations — Choose SSO or Saved credentials and control read and write access.
  • Troubleshooting — Resolve common discovery, schema, permission, query, and capacity issues.