Documentation

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.

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

{%docs-informer info%}

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.

{%docs-informer-end%}

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) {%dropdown-button name="account-url"%}

{%dropdown-body name="account-url"%}

Account URL must satisfy the following regular expression: ```https://[a-z0-9]*.blob.core.windows.net$```.

The ```[a-z0-9]``` part of Account URL must be between 3 and 24 characters in length.

{%dropdown-end%}

3. Enter the SAS Token. (Azure Blob Storage related field) {%dropdown-button name="sas-token"%}

{%dropdown-body name="sas-token"%}

Learn how to create a SAS Token with this guide.

{%dropdown-end%}

4. Enter the Container Name. (Azure Blob Storage related field) {%dropdown-button name="container-name"%}

{%dropdown-body name="container-name"%}

Container Name length must be between 3 and 63 characters and must satisfy the following regular expression: ```r'^(?!.*--.*)[a-z0-9][a-z0-9]*[a-z0-9]$’```

{%dropdown-end%}

5. Select the necessary Encryption type option from the dropdown. (Azure Blob Storage related field) {%dropdown-button name="encryption-type"%}

{%dropdown-body name="encryption-type"%}

Possible options:

• No encryption (default cloud storage encryption is still enabled)
• Customer-provided key

{%dropdown-end%}

6. (Customer-provided keys only) Enter the Encryption key. (Azure Blob Storage related field) {%dropdown-button name="encryption-key"%}

{%dropdown-body name="encryption-key"%}

If you have selected the Default Cloud Storage encryption type, you will not be able to edit this field.

Otherwise, you should enter your AES-256 key, encoded in standard Base64 or resource name of Cloud KMS key used to encrypt the blob’s contents. For more info, see Azure Data Lake encryption docs.

{%dropdown-end%}

7. Enter the SQL Endpoint. {%dropdown-button name="sql-endpoint"%}

{%dropdown-body name="sql-endpoint"%}

SQL Endpoint must satisfy the following regular expression: ```^[a-z0-9\-]*\.[a-z0-9\-]*\.fabric\.microsoft\.com$```.
You can find the SQL Endpoint value in the Data Warehouse settings in Fabric.

{%dropdown-end%}

8. Specify the Schema of your database.
9. Enter the Data Warehouse Name.
10. Enter the Tenant ID.
11. Enter the Client ID.
12. Enter the Client Secret.