Connections - List Connections

Service:: Core

API Version:: v1

Returns a list of on-premises, virtual network and cloud connections the user has permission for.

Permissions

The caller must have permission for the connection.

Required Delegated Scopes

Connection.Read.All or Connection.ReadWrite.All

Microsoft Entra supported identities

This API supports the Microsoft identities listed in this section.

Identity	Support
User	Yes
Service principal and Managed identities	Yes

Interface

GET https://api.fabric.microsoft.com/v1/connections

With optional parameters:

GET https://api.fabric.microsoft.com/v1/connections?continuationToken={continuationToken}

URI Parameters

Name	In	Required	Type	Description
continuationToken	query		string	A token for retrieving the next page of results.

Responses

Name	Type	Description
200 OK	ListConnectionsResponse	OK. The operation was successful.
Other Status Codes	ErrorResponse	Common error codes: UnknownError - An error occurred.

Name

Type

Description

200 OK

ListConnectionsResponse

OK. The operation was successful.

Other Status Codes

ErrorResponse

Common error codes:

UnknownError - An error occurred.

Examples

Example

Sample request

HTTP

GET https://api.fabric.microsoft.com/v1/connections

Sample response

Status code:: 200

{
  "value": [
    {
      "id": "6952a7b2-aea3-414f-9d85-6c0fe5d34539",
      "displayName": "ContosoConnection1",
      "connectivityType": "ShareableCloud",
      "connectionDetails": {
        "type": "Web",
        "path": "https://www.contoso.com"
      },
      "privacyLevel": "Public",
      "credentialDetails": {
        "credentialType": "Anonymous",
        "singleSignOnType": "None",
        "connectionEncryption": "NotEncrypted",
        "skipTestConnection": false
      }
    },
    {
      "id": "f6a39b76-9816-4e4b-b93a-f42e405017b7",
      "displayName": "ContosoConnection2",
      "gatewayId": "58376c10-5f61-4024-887e-748df4beae45",
      "connectivityType": "OnPremisesGateway",
      "connectionDetails": {
        "type": "SQL",
        "path": "contoso.database.windows.net;sales"
      },
      "privacyLevel": "Organizational",
      "credentialDetails": {
        "credentialType": "Basic",
        "singleSignOnType": "None",
        "connectionEncryption": "Any",
        "skipTestConnection": false
      }
    }
  ],
  "continuationToken": "LDEsMTAwMDAwLDA%3D",
  "continuationUri": "https://api.fabric.microsoft.com/v1/connections?continuationToken=LDEsMTAwMDAwLDA%3D"
}

Definitions

Name	Description
ConnectionEncryption	The connection encryption type of the connection. Additional connection encryption values may be added over time.
ConnectivityType	The connectivity type of the connection. Additional connectivity types may be added over time.
CredentialType	The credential type of the connection. Additional credential types may be added over time.
ErrorRelatedResource	The error related resource details object.
ErrorResponse	The error response.
ErrorResponseDetails	The error response details.
ListConnectionDetails	The connection details output for list operations.
ListConnectionsResponse
ListCredentialDetails	The credential details returned when fetching a connection.
OnPremisesGatewayConnection	A connection that connects through on-premises data gateway.
OnPremisesGatewayPersonalConnection	A connection that connects through a personal on-premises data gateway.
PersonalCloudConnection	A connection that connects through the cloud and cannot be shared.
PrivacyLevel	The privacy level setting of the connection. Additional privacy levels may be added over time.
ShareableCloudConnection	A connection that connects through the cloud.
SingleSignOnType	The single sign-on type of the connection. Additional single sign on types may be added over time.
VirtualNetworkGatewayConnection	A connection that connects through a virtual network data gateway.

ConnectionEncryption

Enumeration

The connection encryption type of the connection. Additional connection encryption values may be added over time.

Value	Description
Encrypted	The connection attempt is made using an encrypted connection.
Any	The connection attempt is first made using an encrypted connection, then falls back to unencrypted connection if unsuccessful.
NotEncrypted	The connection attempt is made using an unencrypted connection.

ConnectivityType

Enumeration

The connectivity type of the connection. Additional connectivity types may be added over time.

Value	Description
ShareableCloud	The connection connects through the cloud and can be shared with others.
PersonalCloud	The connection connects through the cloud and cannot be shared with others.
OnPremisesGateway	The connection connects through an on-premises data gateway.
OnPremisesGatewayPersonal	The connection connects through a personal on-premises data gateway.
VirtualNetworkGateway	The connection connects through a virtual network data gateway.
Automatic	The connection connects through the cloud using an implicit data connection. This option is only available for specific scenarios like semantic models that use Single Sign-On (SSO).”
None	The connection is not bound

CredentialType

Enumeration

The credential type of the connection. Additional credential types may be added over time.

Value	Description
Windows	Connection uses Windows authentication to connect. Only supported for on-premises gateways.
Anonymous	Connection uses anonymous authentication to connect.
Basic	Connection uses basic authentication to connect.
Key	Connection uses key authentication to connect.
OAuth2	Connection uses OAuth 2.0 authentication to connect.
WindowsWithoutImpersonation	Connection uses Windows (without the option for impersonation) authentication to connect. Only supported for on-premises gateways (personal mode).
SharedAccessSignature	Connection uses shared access signature (SAS) authentication to connect.
ServicePrincipal	Connection uses service principal authentication to connect.
WorkspaceIdentity	Connection uses workspace identity authentication to connect.

ErrorRelatedResource

Object

The error related resource details object.

Name	Type	Description
resourceId	string	The resource ID that's involved in the error.
resourceType	string	The type of the resource that's involved in the error.

ErrorResponse

Object

The error response.

Name	Type	Description
errorCode	string	A specific identifier that provides information about an error condition, allowing for standardized communication between our service and its users.
message	string	A human readable representation of the error.
moreDetails	ErrorResponseDetails[]	List of additional error details.
relatedResource	ErrorRelatedResource	The error related resource details.
requestId	string	ID of the request associated with the error.

ErrorResponseDetails

Object

The error response details.

Name	Type	Description
errorCode	string	A specific identifier that provides information about an error condition, allowing for standardized communication between our service and its users.
message	string	A human readable representation of the error.
relatedResource	ErrorRelatedResource	The error related resource details.

ListConnectionDetails

Object

The connection details output for list operations.

Name	Type	Description
path	string	The path of the connection.
type	string	The type of the connection.

ListConnectionsResponse

Object

Name	Type	Description
continuationToken	string	The token for the next result set batch. If there are no more records, it's removed from the response.
continuationUri	string	The URI of the next result set batch. If there are no more records, it's removed from the response.
value	Connection[]: OnPremisesGatewayConnection[] OnPremisesGatewayPersonalConnection[] PersonalCloudConnection[] ShareableCloudConnection[] VirtualNetworkGatewayConnection[]	A list of connections returned.

ListCredentialDetails

Object

The credential details returned when fetching a connection.

Name	Type	Description
connectionEncryption	ConnectionEncryption	The connection encryption setting that is used during the test connection.
credentialType	CredentialType	The credential type of the connection.
singleSignOnType	SingleSignOnType	The single sign-on type of the connection.
skipTestConnection	boolean	Whether the connection should skip the test connection during creation and update. True - Skip the test connection, False - Do not skip the test connection.

OnPremisesGatewayConnection

Object

A connection that connects through on-premises data gateway.

Name	Type	Description
connectionDetails	ListConnectionDetails	The connection details of the connection.
connectivityType	string: OnPremisesGateway	The connectivity type of the connection.
credentialDetails	ListCredentialDetails	The credential details of the connection.
displayName	string	The display name of the connection.
gatewayId	string (uuid)	The gateway object ID of the connection.
id	string (uuid)	The object ID of the connection.
privacyLevel	PrivacyLevel	The privacy level of the connection.

OnPremisesGatewayPersonalConnection

Object

A connection that connects through a personal on-premises data gateway.

Name	Type	Description
connectionDetails	ListConnectionDetails	The connection details of the connection.
connectivityType	string: OnPremisesGatewayPersonal	The connectivity type of the connection.
credentialDetails	ListCredentialDetails	The credential details of the connection.
displayName	string	The display name of the connection.
gatewayId	string (uuid)	The gateway object ID of the connection.
id	string (uuid)	The object ID of the connection.
privacyLevel	PrivacyLevel	The privacy level of the connection.

PersonalCloudConnection

Object

A connection that connects through the cloud and cannot be shared.

Name	Type	Description
allowConnectionUsageInGateway	boolean	Allow this connection to be utilized with either on-premises data gateways or VNet data gateways.
connectionDetails	ListConnectionDetails	The connection details of the connection.
connectivityType	string: PersonalCloud	The connectivity type of the connection.
credentialDetails	ListCredentialDetails	The credential details of the connection.
displayName	string	The display name of the connection.
id	string (uuid)	The object ID of the connection.
privacyLevel	PrivacyLevel	The privacy level of the connection.

PrivacyLevel

Enumeration

The privacy level setting of the connection. Additional privacy levels may be added over time.

Value	Description
None	No privacy level setting is configured.
Private	Connections set to private contain sensitive or confidential information. Visibility can be restricted to authorized users. Data from a private connection won't fold in to other connections, including other private connections.
Organizational	Connections set to organizational can fold in to private and other organizational connections. They can't fold in to public connections. Visibility is set to a trusted group.
Public	Files, internet connections, and workbook data can be set to public. Data can fold in to other connections. Visibility is available to everyone.

ShareableCloudConnection

Object

A connection that connects through the cloud.

Name	Type	Description
allowConnectionUsageInGateway	boolean	Allow this connection to be utilized with either on-premises data gateways or VNet data gateways.
connectionDetails	ListConnectionDetails	The connection details of the connection.
connectivityType	string: ShareableCloud	The connectivity type of the connection.
credentialDetails	ListCredentialDetails	The credential details of the connection.
displayName	string	The display name of the connection.
id	string (uuid)	The object ID of the connection.
privacyLevel	PrivacyLevel	The privacy level of the connection.

SingleSignOnType

Enumeration

The single sign-on type of the connection. Additional single sign on types may be added over time.

Value	Description
None	Connection does not use single sign-on to connect.
Kerberos	Connection uses Kerberos single sign-on to connect.
MicrosoftEntraID	Connection uses Microsoft Entra ID single sign-on to connect.
SecurityAssertionMarkupLanguage	Connection uses Security Assertion Markup Language (SAML) single sign-on to connect.
KerberosDirectQueryAndRefresh	Connection uses Kerberos DirectQuery and Refresh single sign-on to connect.

VirtualNetworkGatewayConnection

Object

A connection that connects through a virtual network data gateway.

Name	Type	Description
connectionDetails	ListConnectionDetails	The connection details of the connection.
connectivityType	string: VirtualNetworkGateway	The connectivity type of the connection.
credentialDetails	ListCredentialDetails	The credential details of the connection.
displayName	string	The display name of the connection.
gatewayId	string (uuid)	The gateway object ID of the connection.
id	string (uuid)	The object ID of the connection.
privacyLevel	PrivacyLevel	The privacy level of the connection.

Share via

Connections - List Connections

Permissions

Required Delegated Scopes

Microsoft Entra supported identities

Interface

URI Parameters

Responses

Examples

Example

Sample request

Sample response

Definitions

ConnectionEncryption

ConnectivityType

CredentialType

ErrorRelatedResource

ErrorResponse

ErrorResponseDetails

ListConnectionDetails

ListConnectionsResponse

ListCredentialDetails

OnPremisesGatewayConnection

OnPremisesGatewayPersonalConnection

PersonalCloudConnection

PrivacyLevel

ShareableCloudConnection

SingleSignOnType

VirtualNetworkGatewayConnection