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.

circle-exclamation

Microsoft Fabric Architecture

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

Architecture Layers

Layer
Description

Workloads Layer

Data Factory, Analytics, Warehouses, Real-Time Intelligence, IQ, Power BI

Platform Services Layer

OneLake, Copilot, Governance (Purview), OneLake Catalog

Storage Layer

OneLake (built on Azure Data Lake Storage)

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

circle-info

Governance policies are consistently enforced across all Fabric workloads and extend to shared data scenarios.

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)

circle-info

The component marked as Coming Soon indicates planned support and is not yet available for production use.

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

Component
Support Status
Integration Approach

Fabric Warehouse

Supported

Via Microsoft SQL Server connector using SQL Analytics Endpoint

Power BI

Supported

Existing Power BI connector (on-premises and cloud)

Data Factory

Coming Soon

Planned native integration

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

circle-exclamation

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 herearrow-up-right.

This configuration ensures that the connector can:

  • Query data using the SQL endpoint

  • Access schema and metadata

  • Perform metadata crawling and profiling

circle-info

Viewer-level access (ReadData) is sufficient for metadata extraction and read-only operations.

SQL Server Connector Setup

After access is configured, proceed with the connector setup.

To establish the Microsoft SQL Server connector, click herearrow-up-right.

This setup includes:

  • Defining connection parameters (server, database, port)

  • Selecting authentication method

  • Configuring Credential Manager

  • Validating connectivity

circle-exclamation

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.

circle-info

No separate connector is required for Fabric Power BI. Use the standard Power BI connector, which supports integration with Fabric workspaces.

Power BI Connector Configuration

To integrate reporting assets, click herearrow-up-right 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

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.

circle-exclamation

Future Enhancements

The following capabilities are planned for upcoming releases:

  • Fabric Support for Data Factory

  • Expanded coverage for other components of MS Fabric

circle-info

These enhancements are under evaluation and will be available in future releases. Timelines may vary based on product roadmap priorities.


Copyright © 2026, OvalEdge LLC, Peachtree Corners GA USA

Last updated

Was this helpful?