How to configure a Microsoft Fabric destination

  • Published on Feb 13, 2026
Prev Next

This guide provides instructions on how to locate the necessary credentials and identifiers to connect your Microsoft Fabric Lakehouse. To set up a connection, you will need to gather specific identifiers from the Fabric portal and the Azure portal before configuring the connection.

Early Access

Note that this destination is in early access - please reach out to our Supermetrics support team if you would like access to this destination.

Prerequisites

Workspace ID and Lakehouse ID

These are most easily found directly in the URL when you are viewing your Lakehouse in the browser.

  1. Open your Microsoft Fabric environment.

  2. Navigate to your Workspace, create a new workspace and open the specific Lakehouse item.

  3. Look at the URL in your browser’s address bar. It will follow this format:

    https://app.fabric.microsoft.com/groups/{Workspace_ID}/lakehouses/{Lakehouse_ID}

    1. The string after /groups/ in the URL is your Workspace ID.

    2. The string after /lakehouses/ in the URL is your Lakehouse ID.

Tenant ID, Client ID and Client secret

These values are not found in Fabric; they come from the Azure Portal because you must use an App Registration (Service Principal) to authenticate programmatically.

Follow these steps to get the Tenant ID and Client ID:

  1. Log in to the Azure Portal.

  2. Search for and select Microsoft Entra ID (formerly Azure Active Directory).

  3. Click Add and select App registrations to register a new application.

  4. On the Overview page, you will see:

    1. Application (client) ID - This is your Client ID.

    2. Directory (tenant) ID - This is your Tenant ID.

Follow these steps to get your Client Secret:

  1. While still in your App registration, click Manage and select Certificates & secrets in the left sidebar.

  2. Click + New client secret.

  3. Enter a description and expiry date, then click Add.

    Important to note: Copy the Value and not the Secret ID, and store it in a secure location. This is your Client Secret. It will only be shown once and will not be accessible once you leave the page.

Permissions

Even with correct IDs, your connection will fail unless the Service Principal has access to the Fabric Workspace.

  1. Log in to your Fabric Workspace.

  2. Click Manage Access and select Add people or groups.

  3. Add your Add Regristation (you can search by name or Client ID) and assign it a role of Contributor.

Microsoft Fabric configuration

The configuration stage of creating a new destination in the Supermetrics Hub includes the following fields.

  1. Workspace ID can be found directly in the URL when you are viewing your Lakehouse in the browser.

  2. Lakehouse ID can be found directly in the URL when you are viewing your Lakehouse in the browser.

  3. Upload Path (Onelake Path), you will need to define a path inside your Files folder where the transfer should store the data in Microsoft Fabric.

  4. Output format, currently only Parquet format is available for this destination

  5. Tenant ID refers to the Directory (tenant) ID when registering your App in Microsoft Entra ID on the Azure Portal.

  6. Client ID refers to the Application (client) ID when registering your App in Microsoft Entra ID on the Azure Portal.

  7. Client Secret refers to the Client secret that you generate on the Azure portal.

More resources