Lakehouse · Analytics connector
The Fabric data catalog your whole team can trust.
The Dawiso Fabric connector turns your tenant into a searchable data catalog: every workspace, lakehouse, warehouse, semantic model and Power BI report, with native lineage.
First things first
What is a data connector?
A data connector is the bridge between a tool in your stack and the catalog that gives you a unified view of it. Once a connector is configured, it reaches into the source system on a schedule, reads out the metadata - schemas, tables, dashboards, jobs, ownership, lineage - and represents it inside the catalog. Your actual rows and values stay where they are.
Connectors are the reason a data catalog can answer questions like "which Power BI dashboard depends on this Snowflake table?" or "who owns the orders topic in Kafka?" - automatically, without anyone keeping a spreadsheet up to date.
Three properties separate a good connector from a brittle one: it should be read-only and safe, it should be incremental so a full re-scan isn't required for every refresh, and it should resolve lineage across system boundaries, not just inside one tool.
About the platform
What is Microsoft Fabric?
Microsoft Fabric is the SaaS analytics platform built on OneLake. It unifies Data Factory, Data Engineering, Data Science, Data Warehouse, Real-Time Intelligence and Power BI in one tenant, so a single dataset can be served to ETL, ML and BI without copies. Microsoft positions it as the all-in-one analytics solution for organisations already on Azure and Microsoft 365.
The OneLake Catalog covers what's inside Fabric. What it doesn't cover is the Oracle source that feeds the lakehouse, the Snowflake share alongside Fabric, the Tableau dashboard on the other side of the org, and the data product the business owns end to end. That's where the Dawiso Fabric data catalog joins the picture: read-only, metadata-only, and cross-platform.
Architecture
How Dawiso connects to Fabric
A small read-only role on the Fabric side. The Dawiso scanner pulls metadata on a schedule. Everything ends up in your catalog, business-readable.
Source
Microsoft Fabric tenant
- Workspaces & capacities
- Lakehouses & warehouses
- Semantic models & reports
- Notebooks & pipelines
Dawiso scanner
Read-only metadata
- Schema & object discovery
- Dependency resolution
- SQL flow parsing (optional)
- Sampling on opt-in
Catalog
Dawiso platform
- Searchable metadata
- Lineage & ownership
- Business glossary
- Policy & classifications
Connection details
- Protocol
- Power BI Admin API + Fabric API
- Authentication
- Azure service principal · Entra ID security group · client secret
- Lineage
- Native lineage from Fabric admin APIs (datasets to reports, lakehouses to semantic models); object-level advanced lineage built from view and procedure definitions on enterprise plans
Setup
Connect Fabric in 4 steps
- 01
Register an Entra app
In Azure Portal, register a new application (e.g. Dawiso Integration). Copy the Application (client) ID and Directory (tenant) ID from the Overview page.
- 02
Generate a client secret
Under Certificates & secrets, create a new client secret with an expiration that matches your rotation policy. Copy the value immediately - Azure shows it only once.
- 03
Configure Fabric tenant
Create an Entra security group with the service principal. In Fabric Admin Portal, enable: service principals can call Fabric public APIs, read-only admin APIs, enhance responses with detailed metadata and DAX.
- 04
Grant workspace access
Add the security group to each workspace as Contributor (Viewer ingests basics; Contributor exposes view and procedure definitions for advanced lineage).
Capabilities
What you get with the Fabric connector
-
Workspace & lakehouse catalog
Every Fabric workspace, lakehouse, warehouse, semantic model and report is searchable, with column descriptions, owners and the notebooks behind them.
-
Native + object-level lineage
Lakehouse, warehouse, semantic model and Power BI links come from Fabric admin APIs. View and procedure definitions add object-level advanced lineage on enterprise plans.
-
DAX & M parsing
Enhanced admin API responses with DAX and mashup expressions feed the catalog with semantic-model measures, calculated columns and Power Query steps.
-
Tags & sensitivity in context
Tags and sensitivity labels set in Microsoft Fabric are read into Dawiso, so governance context stays visible alongside Databricks, Snowflake and BigQuery. Read-only, metadata-only.
-
PII classification
Classify a column once. Dawiso flags every Fabric column carrying email, IBAN or government IDs across all workspaces in scope.
-
Ownership & certification
Mark lakehouses, semantic models and reports as certified, deprecated or under review. The owner is visible directly in the catalog.
Business value
Why teams turn on the Fabric connector
- -65%
Fewer 'which report?' pings
Business users find the certified semantic model in Dawiso instead of asking BI which of seven dashboards shows the real revenue number.
- 10x
Faster impact analysis
Before retiring a Fabric lakehouse table, see exactly which semantic models, Power BI reports and downstream warehouses depend on it.
- Audit-ready
GDPR & DORA evidence
Sensitive columns are classified once and the policy follows them through lakehouses, semantic models and reports, with a full audit trail.
Ready to catalog your Fabric?
Set up the connector in an afternoon. See your first lineage graph the same day.
Frequently asked questions
Does Microsoft Fabric have a data catalog?
What is the difference between data catalog and data fabric?
What is a data catalog used for?
What permissions does Dawiso need in Fabric?
What's the difference between Viewer and Contributor access?
Does Dawiso copy our Fabric data?
Power BI or Fabric connector - which one do I pick?
Explore more connectors
Fabric is one of 30+ connectors. Bring your whole stack into the catalog.
-
Data Warehouse Snowflake -
Data Lakehouse Databricks -
Business Intelligence Power BI -
Business Intelligence Tableau -
Data Warehouse Google BigQuery -
Data Warehouse Amazon Redshift