---
title: "How to use Microsoft Fabric with Supermetrics data (Azure Storage & Azure SQL)"
slug: "how-to-use-microsoft-fabric-with-supermetrics-data-azure-storage-azure-sql"
description: "Connect Supermetrics data to Azure Storage or Azure SQL for seamless analytics in Microsoft Fabric. Optimize performance with shortcuts or mirroring options."
updated: 2025-12-17T11:26:43Z
published: 2025-12-17T11:26:43Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to use Microsoft Fabric with Supermetrics data (Azure Storage & Azure SQL)

Supermetrics can deliver your data to Azure Storage or Azure SQL. Microsoft Fabric can then connect to these sources, making your data available for analytics, dashboards, and AI without waiting for a direct Supermetrics-to-Fabric connector. Microsoft and Supermetrics recommend this method.

## Instructions

### Step 1: Deliver data from Supermetrics to Azure Storage or Azure SQL

First, you will need your data available in either Azure Storage or an Azure SQL database to connect with Microsoft fabric. You will find our instructions on how to configure these as a Supermetrics destination in the following articles:

- [How to configure an Azure Storage destination](https://docs.supermetrics.com/docs/how-to-configure-an-azure-storage-destination)
- [How to configure an Azure SQL Database destination](https://docs.supermetrics.com/docs/how-to-configure-an-azure-sql-database-destination)

### Step 2: Connect Microsoft Fabric to your data

****Option 1: If your data is in Azure Storage, use Fabric Shortcuts for fast access****

1. Open Microsoft Fabric and go to your workspace.
2. Create a new Lakehouse or Dataflow Gen2.
3. In the Lakehouse, select **Add shortcut**.
4. Choose either **Azure Data Lake Storage Gen2** or **Azure Blob Storage**.
5. Enter your storage account details and authenticate.
6. Select the container or folder with your Supermetrics data.
7. The shortcut appears in your Lakehouse.

For more details, see [Microsoft’s documentation](https://learn.microsoft.com/en-us/fabric/onelake/create-adls-shortcut) on creating a shortcut to Azure Data Lake Storage Gen2 in OneLake.

> [!NOTE]
> Alternative: Use Data Factory for ETL
> 
> If you need to transform or copy data in Fabric’s OneLake for performance or historical snapshots, use Fabric’s built-in Data Factory.

****Option 2: If your data is in Azure SQL, use Fabric Mirroring for real-time sync****

1. Open Microsoft Fabric and go to your workspace.
2. Select **New → Mirror**.
3. Choose Azure SQL Database as your source.
4. Enter your Azure SQL connection details.
5. Authenticate and select the tables to mirror.
6. Configure mirroring options, either full or incremental.
7. Start mirroring.

For more details, see [Microsoft’s documentation](https://learn.microsoft.com/en-us/fabric/mirroring/azure-sql-database) on Mirroring Azure SQL Database.

### Step 3: Analyze and visualise in Microsoft Fabric

When you have Microsoft Fabric connected to your data in either Azure Storage or Azure SQL Database, you can use Power BI, Notebooks, or Dataflows in Fabric to analyze and visualize your Supermetrics data.

Both Lakehouse and Warehouse options support SQL queries and Power BI integration. [Microsoft’s documentation](https://learn.microsoft.com/en-us/fabric/fundamentals/decision-guide-lakehouse-warehouse) can help you choose which option is best for you.

## Best practices

- Using Shortcuts is faster for access and freshness, but may be slower for heavy analytics. We recommend using Data Factory or mirroring for large and complex workloads for better performance.
- For better performance, use fewer, larger files (for example, daily Parquet files) are preferred over thousands of smaller files.
- Partition your data by date, customer for efficient querying.
- Set up alerts for failed transfers or refreshes.
- Separate your data by team or use case for security and manageability.
- Ensure both Supermetrics and Fabric have the right access to your Azure resources.

## More resources

- [How to configure an Azure SQL Database destination](https://docs.supermetrics.com/v1/docs/how-to-configure-an-azure-sql-database-destination)
- [About Azure Storage prerequisites](https://docs.supermetrics.com/v1/docs/about-azure-storage-prerequisites)
- [How to create a destination](https://docs.supermetrics.com/v1/docs/how-to-connect-to-a-data-warehouse-destination)
- [How to create a transfer](https://docs.supermetrics.com/v1/docs/how-to-create-a-transfer)