Microsoft Fabric

Microsoft Fabric (opens new window) is a unified analytics platform that integrates Data engineering, Data integration, Data warehousing, Real-Time Analytics, and Business Intelligence (Power BI) into a unified platform.

Prerequisites

Before using the Microsoft Fabric connector in Workato, ensure you have completed the following steps.

1

Sign in to the Azure portal (opens new window) > go to Microsoft Entra ID (Ensure your account has the required roles (opens new window) such as Application Developer, Cloud Application Administrator, or Global Administrator.)

2

Switch to the correct tenant (if applicable) by clicking on Account profile > Switch directory. Select the tenant where you want to register the app.

3

Navigate to App registrations > New registration.

4

Enter Name and select Supported account types.

5

Enter https://workato.com/oauth/callback as the Redirect URI and set the platform to Web.

6

Click Register.

7

On the Overview page, copy Application (client) ID and Directory (tenant) ID.

8

Go to Certificates & secrets > New client secret.

9

Enter Description and select the Expiration date > click Add. Copy Secret value and store it securely.

SCOPES

You do not need to assign API permissions as the connector requests only the required scopes.

How to connect to Microsoft Fabric

MICROSOFT MFA ENFORCEMENT

Microsoft is rolling out mandatory multi-factor authentication (MFA) (opens new window) gradually to different applications and accounts in phases. This enforcement will continue throughout 2025 and beyond.

We strongly recommend enabling MFA now for all Microsoft accounts used with Workato to avoid service disruptions from short-notice enforcement changes.

Complete the following steps to maintain uninterrupted service:

1

Enable MFA for your Microsoft organization following Microsoft's MFA setup guide (opens new window).

2

Reconnect your Microsoft connection in Workato.

3

Complete the OAuth flow with MFA when prompted.

4

Test your recipes to ensure they work with the updated connection.

Follow the steps below to set up a connection between Workato and Microsoft Fabric.

1

Click Create > Connection.

2

Search for and select Microsoft Fabric as your connection on the New Connection page.

3

Provide a unique name for your connection in the Connection name field.

Microsoft Fabric Connection

4

Select the Location of the folder to save your connection.

5

Enter the Client ID and Client secret for the Azure Active Directory app.

6

Enter the Account type of the Azure Active Directory app.

7

Based on the selected Account type, enter the Tenant ID.

8

Click Connect.

ADDITIONAL SCOPES

If scopes are required, in addition to the basic scopes requested by default, you may enter them in the Scopes field in the suggested format.