Integration · Microsoft Fabric

    Your Fabric data in plain questions and alerts.

    Datahub connects to your Fabric warehouse or lakehouse. Questions, insights and alerts run live on your own tables, without copying rows.

    Orders in backlogThresholdAlertLive on your warehouse, no copy
    • Live

      No copy

      Datahub queries the data live in Fabric and copies no rows.

    • One connection

      Warehouse or lakehouse

      One SQL endpoint: a Data Warehouse or a Lakehouse SQL analytics endpoint.

    • Reading is enough

      With the Viewer role

      Read access is enough for questions and insights. Datahub signs in with a service principal from Entra ID.

    What you can ask

    Questions to your own tables, in plain language.

    • “How many orders were processed this week?”

    • “Which customers grew the most this quarter?”

    • “What is the stock value per branch?”

    • “How big is the order backlog today?”

    • “What was the revenue per month this year?”

    • “Which columns are in the orders table?”

    What happens

    From table to metric, without moving your data.

    In Datahub's builders you browse Fabric's catalogs, schemas, tables and columns. A metric, insight or alert then reads live from those tables.

    Warehousesalesordersidorder_dateamountcustomerslinesMetricOrders per week

    Pick a column, build a metric.

    • Yes

      What it does

      One connection to your Fabric endpoint for everything below.

      • Questions in plain language
      • Insights and dashboards
      • Alerts on query results
      • Browsing schemas, tables and columns
    • Sign-in

      A service principal

      Datahub signs in with an app from your own Entra ID.

      • Tokens renewed automatically
      • Client secret kept in the integration settings
      • Read access (Viewer) is enough
    • Not

      What it does not do

      The connection is not meant for these.

      • Loading Delta tables through Spark
      • Running Fabric notebooks
      • Signing in per user
    Where you use it

    One connection, three places.

    • Questions

      Answers from your tables

      Ask a question in plain language and Datahub looks up the answer in Fabric.

    • Insights

      Next to your other sources

      Insights and dashboards on Fabric sit next to those on Databricks and the catalog.

    • Alerts

      Told when it matters

      An alert fires when a query result crosses a threshold, to Teams or Outlook for example.

    How to connect Fabric

    From Fabric to your first answer in four steps.

    1. 01

      Register an app

      An administrator registers an app in Entra ID and creates a client secret.

    2. 02

      Grant access

      Allow service principals in the Fabric admin portal and give the app access to the workspace.

    3. 03

      Enter the endpoint

      Enter the hostname, the warehouse name and the app's details in Datahub and test the connection.

    4. 04

      First question

      Ask a question, build an insight or set an alert on a threshold.

    Frequently asked questions

    What data teams ask before they connect.

    Next step

    Ask Fabric your first question.

    An intro call maps which warehouses and lakehouses you run and what it takes to connect them.