Using BimlFlex with Microsoft Fabric

Microsoft Fabric is a unified analytics platform provided by Microsoft that brings together data engineering, data integration, data warehousing, data science, real-time analytics, and business intelligence into a single SaaS experience. BimlFlex extends metadata-driven automation to the Fabric ecosystem, enabling customers to design and generate data solutions directly within the platform.

BimlFlex supports Microsoft Fabric as both a source and target platform, providing load patterns that use BimlFlex metadata to create the required ETL and ELT processes for loading data warehouses in Fabric.

Quick Start with Sample Metadata

The fastest way to get started with Microsoft Fabric is to load one of the pre-configured sample metadata sets:

Sample	Description	Use Case
Fabric Data Vault	Pre-configured for Data Vault implementation	Building a silver layer with Hub, Link, and Satellite patterns
Fabric Datamart	Pre-configured for dimensional modeling	Building bronze-to-gold layer data marts

To load a sample:

1. Navigate to the BimlFlex Dashboard
2. Select from the Load Sample Metadata dropdown
3. Choose either Fabric Data Vault or Fabric Datamart

Supported Fabric Components

BimlFlex provides support for the following Microsoft Fabric components:

Fabric Lakehouse

Full support for Microsoft Fabric Lakehouse, providing capabilities similar to the Databricks and Snowflake integrations. This includes:

• Metadata Import Support
• Medallion Architecture Support (Bronze/Silver/Gold layers)
• Data Vault Templates (Hubs, Links, Satellites, PIT/Bridge tables)
• Data Mart Templates
• Delete Detection Templates

Fabric Warehouse

Full support for Microsoft Fabric Warehouse, enabling structured, SQL-based analytics with:

• Metadata Import Support
• Data Vault Templates
• Data Mart Templates optimized for Fabric's T-SQL query engine
• Delete Detection Templates

tip

Please take note of these additional resources on working with Microsoft Fabric:

• Microsoft Fabric Website
• Microsoft Fabric Documentation
• Microsoft Fabric Lakehouse Documentation
• Microsoft Fabric Warehouse Documentation

Implementing Fabric Solutions

• Configuring BimlFlex for Microsoft Fabric
• Implementing Fabric Lakehouse with Data Factory
• Implementing Fabric Warehouse with Data Factory

Benefits of Using BimlFlex with Fabric

With BimlFlex, your team only needs to understand data modeling: you don't need to write notebooks, stored procedures, or pipeline code. All code is generated automatically based on your metadata, including:

• Notebooks: For Fabric Lakehouse processing
• Stored Procedures: For Fabric Warehouse transformations
• Data Factory Pipelines: Complete orchestration with copy activities, error handling, and incremental loading

As Microsoft Fabric evolves, BimlFlex templates are updated to ensure your implementations remain optimal.