---
title: "Microsoft Fabric"
slug: "microsoft-fabric"
description: "Dataddo's Microsoft Fabric destination allows you to seamlessly integrate and store your data with specific configuration options for optimized performance."
updated: 2026-03-18T19:04:21Z
published: 2026-03-18T19:04:21Z
---

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

# Microsoft Fabric

**Microsoft Fabric** is an AI-powered, unified analytics platform that brings together all the data tools an organization needs into a single Software-as-a-Service (SaaS) environment. It centralizes all data in its built-in data lake, OneLake, and features workloads like Data Factory and Power BI to simplify the entire data lifecycle and enable faster, data-driven decisions.

## Authorize the Connection to Microsoft Fabric

To authorize the connection to Microsoft Fabric, choose one of the following methods.

| Method | Advantage |
| --- | --- |
| [OAuth 2.0](/docs/microsoft-fabric#oauth-20-authorization) | Standard authorization method using your Microsoft account. |
| [Service Principal Authorization](/docs/microsoft-fabric#service-principal-authorization) | Suitable for more complex deployments. |

**DATADDO TIP**

If you don't have the required permissions to authenticate your service, assign the [authorizer role](/docs/user-roles#authorizer) to a team member with these permissions.

### OAuth 2.0 Authorization

To authorize this service, use **OAuth 2.0** to share specific data with Dataddo while keeping usernames, passwords, and other information private.

1. On the **Authorizers** page, click on [Authorize New Service](https://app.dataddo.com/service/new) and select your service.
2. Follow the on-screen prompts to grant Dataddo the necessary permissions to **access and retrieve** your data.
3. **[Optional]** Once your ***authorizer*** is created, click on it to **change the label** for easier identification.

Ensure that the account you're granting access to holds at least **admin-level permissions**. If necessary, assign a team member with the required permissions with the [authorizer role](https://docs.dataddo.com/docs/user-roles#authorizer) to authenticate the service for you.

### Service Principal Authorization

#### In Azure Portal

**Register an Application in Microsoft Entra ID**

1. Sign in to the **Azure Portal** and open **Microsoft Entra ID**.
2. Under **Manage**, navigate to **App registrations** and click **+ New registration**.
3. Enter a **Name** (e.g., Dataddo -Microsoft Fabric).
4. Select the **Supported account types**. We recommend **Accounts in this organizational directory only**.
5. Click **Register**.
6. From the **Overview** page, copy and save the **Application (Client) ID** and **Directory (Tenant) ID**.

**Create a Client Secret**

1. Navigate to **Certificates & secrets** and click **New client secret**.
2. Provide a description and select an expiration period.
3. Click **Add**.
4. Copy the **Value** of the client secret immediately. Store it securely, as it will not be visible again.

**Configure API Permissions**

1. Open **API permissions** and click **Add a permission**.
2. Follow your organization’s governance policy to add the required scopes.
3. For ***Microsoft Fabric***, no manual scopes are required beyond the default resource scope: `https://api.fabric.microsoft.com/.default`.

**Grant Admin Consent**

If your tenant enforces administrator approval, click **Grant admin consent for [Your Organization]** on the **API permissions** page.

**Enable Service Principal Access in Fabric**

If you are connecting to ***Microsoft Fabric***, you must enable access in the **Microsoft Fabric Admin Portal**.

1. Go to the **Tenant settings**.
2. Enable the setting **Service principals can use Fabric APIs**.

#### In Dataddo

1. On the [Authorizers](https://app.dataddo.com/authorizers) page, click **Create authorizer**.
2. Select **Microsoft Service Principal**.
3. Provide the following credentials:
  - **Tenant ID**
  - **Client ID**
  - **Client Secret**
4. Select the following scopes:
  - `FABRIC_DEFAULT`
  - `OFFLINE_ACCESS`
  - `EMAIL`
  - `OPENID`
5. Save the authorizer.

## Create a New Microsoft Fabric Destination

1. On the **Destinations** page, click on the [**Create Destination**](https://app.dataddo.com/destinations) button and select the destination from the list.
2. Select your ***authorizer*** from the drop-down menu.
Need to authorize another connection?

```
 Click on **Add new Account** in drop-down menu during ***authorizer*** selection and follow the on-screen prompts. You can also go to the **Authorizers** tab and click on [**Add New Service**](https://app.dataddo.com/service/new){target="_blank"}.
```
3. Select which **Workspace** and **Lakehouse** to load data to.
4. [Optional] Direct the data into a specific folder or table, e.g. `/Documents/`.
5. Name your ***destination*** and click on **Save**.

## Create a Flow to Microsoft Fabric

1. Navigate to **Flows** and click on [**Create Flow**](https://app.dataddo.com/flow/new).
2. Click on **Connect Your Data** to add your ***source(s)***.
3. Click on **Connect Your Data Destination** to add the ***destination***.
4. Select your **Filename Format**. We support the following formats: `JSON`, `JSONL` `CSV`, `XML`, `XLXS`, `PARQUET`.

| CSV | Parquet |
| --- | --- |
| If you select **CSV**, you can also configure: - The CSV delimiter. You can select from the following delimiters: comma `,`, semicolon `;`, or tab `\t`, or pipe `\|`. - Whether **null dates** are shown as **empty**. If not enabled, null dates will be displayed as `1970-01-01`. - Whether the first row is defined as the table header. Do not enable if you prefer **raw data**. | If you select **parquet**, you can also select one of the following timestamp units: - **Millis** is short for milliseconds. - **Micros** is short for microseconds. - **Nanos** is short for nanoseconds. |
5. Select your **File Name** pattern or use a custom one. For more information on custom names using date ranges, see the section on [File Partitioning](/docs/microsoft-fabric#file-partitioning)
6. Choose the [write mode](https://docs.dataddo.com/docs/data-storages#write-modes).
7. Check the **Data Preview** to see if your configuration is correct.
8. **Name** your flow and click on **Create Flow** to finish the setup.

---

### File Partitioning

File partitioning **splits large datasets into smaller, manageable partitions**, based on criteria like date. This technique enhances data organization, query performance, and management by grouping subsets of data with shared attributes.

During ***flow*** creation, you can:

- Select one of the **predefined file name patterns**.
- Define your own **custom name** to  suit your partitioning needs.

**Example of a custom file name** When creating a custom file name, use variations of the offered file names.

For example, use a **base file** name and add a different **date range** pattern:

```
xyz_{{1d1|Ymd}}
```

Using this file name, Dataddo will create a new file named `xyz` every day, e.g. `xyz_20xx0101`, `xyz_20xx0102` etc.

For more information, see [Dynamic File Naming Patterns](/docs/dynamic-file-naming-patterns).

## Troubleshooting

### Invalid resource Error

**ERROR MESSAGE**

```
invalid_client - AADSTS650057:+Invalid+resource
```

This error may be caused by one of the following issues:

1. **Missing API Permissions**: Go to your app's registration in the Microsoft Entra ID portal and ensure you have added the correct API permissions for the resource you're connecting to. **Admin Consent** must be granted.
2. **Database View Connection**: This issue is caused by attempting a connection to a **Database View**, which by itself is insufficient. Connect to the underlying physical database instance that hosts that view, not the view layer itself.

## Related Articles

- [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages)
- [Write Modes](https://docs.dataddo.com/docs/data-storages#write-modes)
- [Implementation of Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses)
- [Network Access Control List (ACL) Configuration](https://docs.dataddo.com/docs/network-acl)
- [SSH Tunnelling](https://docs.dataddo.com/docs/ssh-tunnelling)
- [Data Transformations](https://docs.dataddo.com/docs/data-transformations)
- [Data Quality Firewall](https://docs.dataddo.com/docs/data-quality-firewall)