Improvado
Esc

Start typing to search.

Improvado
Sign In

Microsoft Fabric

Updated on May 12, 2025

Note: Microsoft Fabric is currently supported only as a Destination. This guide doesn’t cover the DataPrep setup for Microsoft Fabric.

Improvado currently supports Microsoft Fabric authentication only through Microsoft Entra ID.

Description

Microsoft Fabric is a unified, cloud-powered analytics platform that streamlines data ingestion, integration, and analysis. It provides a secure environment to connect diverse data sources, build robust data pipelines, and drive actionable insights—all within a single, scalable workspace.

Setup guide

Follow our setup guide to connect Microsoft Fabric to Improvado.

App registration

  1. Go to the application registration portal (Applications > App registrations > New registration).
  2. Register a new application and create a Service Principal. Leave the Redirect URI field empty.
  3. After creating the application, navigate to its details page.
  4. Copy the Client ID and Tenant ID values.
  5. Generate a client secret in the application settings. Copy the newly generated value.
  6. Open Fabric and navigate to the relevant workspace.
  7. Click Manage Access.
  8. Search for the newly created application and grant it the Contributor role.

Refer to the official App registration guide if necessary.

Complete configuration

Note

In our workflow, Improvado uses Azure Blob Storage as an intermediate data destination. This requires you to have both Azure Blob Storage and Microsoft Fabric in place. Data is first loaded into Azure Blob and subsequently copied into Fabric. Everything is streamlined through the Microsoft Fabric page on our UI, meaning you don't need a separate connection for Azure Blob.

On the Microsoft Fabric connection page, fill in the following fields:

  1. Enter a name for your Destination connection in the Title.
  2. Enter the Account URL. (Azure Blob Storage related field)
  1. Enter the SAS Token. (Azure Blob Storage related field)
  1. Enter the Container Name. (Azure Blob Storage related field)
  1. Select the necessary Encryption type option from the dropdown. (Azure Blob Storage related field)
  1. (Customer-provided keys only) Enter the Encryption key. (Azure Blob Storage related field)
  1. Enter the Client ID.
  2. Enter the Client Secret.
  3. Enter the Tenant ID.
  4. Enter the SQL Endpoint.
  1. Enter the Data Warehouse Name.
  2. Specify the Schema of your database.
  3. Select the necessary Use binary strings option from the dropdown.

‍

Was this article helpful?