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.
Microsoft Fabric operates on a shared data model, enabling cross-workload data access without duplication.
Microsoft Fabric Architecture
Microsoft Fabric is built on a unified SaaS foundation that integrates multiple workloads within a single environment.
Architecture Layers
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
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)
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
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
Select the authentication method based on the deployment model and security policies.
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.
This configuration ensures that the connector can:
Query data using the SQL endpoint
Access schema and metadata
Perform metadata crawling and profiling
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 here.
This setup includes:
Defining connection parameters (server, database, port)
Selecting authentication method
Configuring Credential Manager
Validating connectivity
Ensure that the SQL Analytics Endpoint is reachable and properly configured before initiating connection setup.
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.
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 here 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.
Connectivity validation must be completed before enabling metadata extraction to avoid incomplete ingestion or failures.
Future Enhancements
The following capabilities are planned for upcoming releases:
Fabric Support for Data Factory
Expanded coverage for other components of MS Fabric
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?