Connecting to Microsoft Fabric

Prev Next

Syniti Knowledge Platform (SKP) allows you to connect to Microsoft Fabric.

Prerequisites

  1. Register a Microsoft Entra app and create a Service Principal

    • In App registrations, note the values for the following fields: Application (client) ID and Directory (tenant) ID

    • In the newly created app, access Certificates & secrets, add a new client secret, and then copy the secret value.

  2. Create a system datastore connection in the SKP using the MS Fabric type with connection properties listed below.

Connection Properties

Field Name

Description

Notes

Name
(Required)

Name of the Fabric connection unique to the SKP.

Not applicable

Description

Enter a description that briefly states the purpose of this connection.

Not applicable

Hostname
(Required)

The Fabric warehouse name you want to connect to.

Extract the warehouse name and port number from your fabric warehouse connection string.

For example, <unique identifier>.datawarehouse.fabric.microsoft.com.

Refer to Connect to Fabric Data Warehouse for more information on how to obtain the connection string.

Port

The port number your Fabric workspace uses to accept connections.

By default, the Fabric warehouse’s port number is 1433. If you are not sure, you can use this default port.

Database/Warehouse

(Required)

The name of the SQL database or Warehouse item in your Fabric workspace.

Refer to Find and explore data in the OneLake catalog for more information on identifying your Fabric item.

Tenant ID

(Required)

Enter the Directory (tenant) ID that uniquely identifies your organization in Microsoft Entra ID.

See the Prerequisites section to obtain this value.

Client ID

(Required)

Enter the Application (client) ID that uniquely identifies your registered application in Microsoft Entra ID.

See the Prerequisites section to obtain this value.

Client Secret

(Required)

Enter the client secret generated for your application in Microsoft Entra ID. This secret is used to authenticate the application when accessing MS Fabric’s workspace item resources securely.

See the Prerequisites section to obtain this value.

Extended Properties

Use the + Add Property button to add any additional connection properties.

Not applicable

Create a Connection