# Microsoft Fabric

This article outlines Microsoft Fabric integration capabilities within the OvalEdge application, focusing on supported components, connectivity mechanisms, and upcoming enhancements. It provides clarity on current support, integration patterns, and configuration considerations to ensure consistent implementation and governance alignment.

It provides a structured view of how Microsoft Fabric assets can be integrated, governed, and accessed using existing connectors and planned enhancements. The objective is to ensure consistent metadata management, lineage visibility, and secure data access across Fabric workloads.

### What is Microsoft Fabric

Microsoft Fabric is a unified, SaaS-based analytics platform that enables end-to-end data workflows, including ingestion, transformation, processing, analytics, and reporting within a single environment.

Fabric consolidates multiple analytics experiences, such as Data Engineering, Data Factory, Data Science, Real-Time Intelligence, Data Warehouse, Databases, and Power BI, into a shared platform operating on a common compute and storage foundation.

{% hint style="warning" %}
Microsoft Fabric operates on a shared data model, enabling cross-workload data access without duplication.
{% endhint %}

### Microsoft Fabric Architecture

Microsoft Fabric is built on a unified SaaS foundation that integrates multiple workloads within a single environment.

#### Architecture Layers

<table><thead><tr><th width="221.27276611328125">Layer</th><th>Description</th></tr></thead><tbody><tr><td>Workloads Layer</td><td>Data Factory, Analytics, Warehouses, Real-Time Intelligence, IQ, Power BI</td></tr><tr><td>Platform Services Layer</td><td>OneLake, Copilot, Governance (Purview), OneLake Catalog</td></tr><tr><td>Storage Layer</td><td>OneLake (built on Azure Data Lake Storage)</td></tr></tbody></table>

#### Core Architectural Elements

* **OneLake**: Centralized logical data lake enabling storage and access across all workloads without data duplication
* **OneLake Catalog**: A unified interface for discovering, exploring, and governing data assets across the environment. It provides visibility into metadata, governance status, and data usage.
* **Copilot Integration**: AI-assisted capabilities embedded across workloads for development and analysis tasks
* **Governance (Purview)**: Provides centralized access control, sensitivity labels, auditing, and compliance enforcement

{% hint style="info" %}
Governance policies are consistently enforced across all Fabric workloads and extend to shared data scenarios.
{% endhint %}

### Microsoft Fabric – Supported Components

Microsoft Fabric is a unified analytics platform that includes multiple services. The following components are relevant for integration:

* Data Factory (Coming Soon)
* Warehouses (Supported via existing Microsoft SQL Server connector)
* Power BI (Supported via existing Power BI connector)

{% hint style="info" %}
The component marked as Coming Soon indicates planned support and is not yet available for production use.
{% endhint %}

### Scope

The integration aims to improve visibility and governance of Microsoft Fabric assets by leveraging existing connector capabilities and planned enhancements.

* Provide visibility into Fabric Warehouse through existing SQL Server-based connectivity.
* Enable Power BI integration using the current Power BI connector.
* Establish a foundation for onboarding Data Factory in future releases.

### Supported Connectivity

Microsoft Fabric supports connectivity to Microsoft SQL Server environments deployed across multiple infrastructures. Integration is enabled through standardized authentication and connector configurations.

#### Connectivity Scope

<table><thead><tr><th width="184.45452880859375">Component</th><th width="159.1817626953125">Support Status</th><th>Integration Approach</th></tr></thead><tbody><tr><td>Fabric Warehouse</td><td>Supported</td><td>Via Microsoft SQL Server connector using SQL Analytics Endpoint</td></tr><tr><td>Power BI</td><td>Supported</td><td>Existing Power BI connector (on-premises and cloud)</td></tr><tr><td>Data Factory</td><td>Coming Soon</td><td>Planned native integration</td></tr></tbody></table>

### Fabric Warehouse Integration

Access to Microsoft Fabric Warehouse through the SQL Analytics Endpoint is authenticated using Azure Active Directory.

#### Supported Authentication Methods

* Managed Identity (User Assigned)
* Service Principal

{% hint style="warning" %}
Select the authentication method based on the deployment model and security policies.
{% endhint %}

#### Fabric Warehouse Access Configuration

Before establishing connectivity, the appropriate access level must be configured at the Fabric Warehouse level.

To configure access for Microsoft Fabric Warehouse, click [here](https://docs.ovaledge.com/release8.1/connectors/connector-repositories/unified-data-and-ai-platforms/microsoft-fabric/access-configuration-for-microsoft-fabric-warehouse).

This configuration ensures that the connector can:

* Query data using the SQL endpoint
* Access schema and metadata
* Perform metadata crawling and profiling

{% hint style="info" %}
Viewer-level access (ReadData) is sufficient for metadata extraction and read-only operations.
{% endhint %}

#### SQL Server Connector Setup

After access is configured, proceed with the connector setup.

To establish the Microsoft SQL Server connector, click [here](https://docs.ovaledge.com/release8.1/connectors/connector-repositories/rdbms/microsoft-sql-server).

This setup includes:

* Defining connection parameters (server, database, port)
* Selecting authentication method
* Configuring Credential Manager
* Validating connectivity

{% hint style="warning" %}
Ensure that the SQL Analytics Endpoint is reachable and properly configured before initiating connection setup.
{% endhint %}

<figure><img src="/files/UmEbnCQqbDwtZKHcduGS" alt=""><figcaption></figcaption></figure>

### Integration with Power BI

Microsoft Fabric Power BI capabilities are integrated using the existing Power BI connector.

* Supports both on-premises and cloud environments
* Enables ingestion of reports, datasets, and dashboards
* Maintains consistency with existing metadata ingestion and lineage tracking.

{% hint style="info" %}
No separate connector is required for Fabric Power BI. Use the standard Power BI connector, which supports integration with Fabric workspaces.
{% endhint %}

#### Power BI Connector Configuration

To integrate reporting assets, click [here](https://docs.ovaledge.com/release8.1/connectors/connector-repositories/reporting-tool/power-bi) to configure Power BI (Cloud and On-Prem) connectors.

Connector setup includes:

* Selecting server type (Cloud / On-Prem)
* Configuring authentication (Service Principal or Service User)
* Enabling metadata extraction and lineage tracking

<div align="left"><figure><img src="/files/6rWbs3kMgk5DoCm1WpXa" alt=""><figcaption></figcaption></figure></div>

### Configuration and Setup

Connector configuration follows standard procedures using the platform’s connector framework.

* Configure the connection using Credential Manager
* Select an appropriate authentication method
* Provide the required endpoint and access details
* Validate connectivity before enabling crawling and profiling.

{% hint style="warning" %}
Connectivity validation must be completed before enabling metadata extraction to avoid incomplete ingestion or failures.
{% endhint %}

### Future Enhancements

The following capabilities are planned for upcoming releases:

* Fabric Support for Data Factory
* Expanded coverage for other components of MS Fabric

{% hint style="info" %}
These enhancements are under evaluation and will be available in future releases. Timelines may vary based on product roadmap priorities.
{% endhint %}

***

Copyright © 2026, OvalEdge LLC, Peachtree Corners GA USA


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ovaledge.com/release8.1/connectors/connector-repositories/unified-data-and-ai-platforms/microsoft-fabric.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.