Connections - Update Connection
Updates connection by ID.
To encrypt credentials, see Configure credentials programmatically.
Permissions
The caller must have permission for the connection or admin permission for the gateway of the connection.
Required Delegated Scopes
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
PATCH https://api.fabric.microsoft.com/v1/connections/{connectionId}
URI Parameters
Name | In | Required | Type | Description |
---|---|---|---|---|
connection
|
path | True |
string (uuid) |
The ID of the connection. |
Request Body
The request body can be one of the following:
UpdateOnPremisesGatewayConnectionRequest
Name | Required | Type | Description |
---|---|---|---|
connectivityType | True |
string:
On |
The connectivity type of the connection. |
credentialDetails |
The credential details of the connection. |
||
displayName |
string |
The display name of the connection. Maximum length is 200 characters. |
|
privacyLevel |
The privacy level of the connection. |
UpdateOnPremisesGatewayPersonalConnectionRequest
Name | Required | Type | Description |
---|---|---|---|
connectivityType | True |
string:
On |
The connectivity type of the connection. |
credentialDetails |
The credential details of the connection. |
||
privacyLevel |
The privacy level of the connection. |
UpdatePersonalCloudConnectionRequest
Name | Required | Type | Description |
---|---|---|---|
connectivityType | True |
string:
Personal |
The connectivity type of the connection. |
allowConnectionUsageInGateway |
boolean |
Allow this connection to be utilized with either on-premises data gateways or VNet data gateways. |
|
credentialDetails |
The credential details of the connection. |
||
privacyLevel |
The privacy level of the connection. |
UpdateShareableCloudConnectionRequest
Name | Required | Type | Description |
---|---|---|---|
connectivityType | True |
string:
Shareable |
The connectivity type of the connection. |
allowConnectionUsageInGateway |
boolean |
Allow this connection to be utilized with either on-premises data gateways or VNet data gateways. |
|
credentialDetails |
The credential details of the connection. |
||
displayName |
string |
The display name of the connection. Maximum length is 200 characters. |
|
privacyLevel |
The privacy level of the connection. |
UpdateVirtualNetworkGatewayConnectionRequest
Name | Required | Type | Description |
---|---|---|---|
connectivityType | True |
string:
Virtual |
The connectivity type of the connection. |
credentialDetails |
The credential details of the connection. |
||
displayName |
string |
The display name of the connection. Maximum length is 200 characters. |
|
privacyLevel |
The privacy level of the connection. |
Responses
Name | Type | Description |
---|---|---|
200 OK | Connection: |
OK. The operation was successful. |
Other Status Codes |
Common error codes:
|
Examples
On-premises gateway (personal mode) example |
On-premises gateway example |
Personal cloud example |
Shareable cloud example |
Virtual network gateway example |
On-premises gateway (personal mode) example
Sample request
PATCH https://api.fabric.microsoft.com/v1/connections/ef8f408d-2ab7-4a18-b662-9251febda49c
{
"connectivityType": "OnPremisesGatewayPersonal",
"credentialDetails": {
"credentials": {
"credentialType": "WindowsWithoutImpersonation",
"encryptedCredentials": "************************************"
}
}
}
Sample response
{
"id": "ef8f408d-2ab7-4a18-b662-9251febda49c",
"gatewayId": "429a773e-5633-45ee-8584-a192bd79c16a",
"connectivityType": "OnPremisesGatewayPersonal",
"connectionDetails": {
"type": "SQL",
"path": "contoso.database.windows.net;reporting"
},
"privacyLevel": "Private",
"credentialDetails": {
"credentialType": "WindowsWithoutImpersonation",
"singleSignOnType": "None",
"connectionEncryption": "NotEncrypted",
"skipTestConnection": false
}
}
On-premises gateway example
Sample request
PATCH https://api.fabric.microsoft.com/v1/connections/70b17680-48f1-4729-9df6-02576647dc3a
{
"connectivityType": "OnPremisesGateway",
"displayName": "ContosoSalesOnPremisesConnection",
"credentialDetails": {
"skipTestConnection": false,
"credentials": {
"credentialType": "Windows",
"values": [
{
"gatewayId": "4f8b5d6e-8e99-4817-8b9e-6b6a613be707",
"encryptedCredentials": "************************************"
},
{
"gatewayId": "c6961028-1309-4183-9799-a0b0fa28a235",
"encryptedCredentials": "************************************"
}
]
}
}
}
Sample response
{
"id": "70b17680-48f1-4729-9df6-02576647dc3a",
"displayName": "ContosoSalesOnPremisesConnection",
"gatewayId": "4f8b5d6e-8e99-4817-8b9e-6b6a613be707",
"connectivityType": "OnPremisesGateway",
"connectionDetails": {
"type": "SQL",
"path": "contoso.database.windows.net;sales"
},
"privacyLevel": "Organizational",
"credentialDetails": {
"credentialType": "Windows",
"singleSignOnType": "None",
"connectionEncryption": "NotEncrypted",
"skipTestConnection": false
}
}
Personal cloud example
Sample request
PATCH https://api.fabric.microsoft.com/v1/connections/7a0369b2-58c4-4b67-b3f3-92156a95f1cd
{
"connectivityType": "PersonalCloud",
"privacyLevel": "Organizational"
}
Sample response
{
"id": "7a0369b2-58c4-4b67-b3f3-92156a95f1cd",
"connectivityType": "PersonalCloud",
"connectionDetails": {
"type": "SQL",
"path": "contoso.database.windows.net;finances"
},
"privacyLevel": "Organizational",
"credentialDetails": {
"credentialType": "OAuth2",
"singleSignOnType": "None",
"connectionEncryption": "NotEncrypted",
"skipTestConnection": false
}
}
Shareable cloud example
Sample request
PATCH https://api.fabric.microsoft.com/v1/connections/fa968eee-8075-48f6-8c6d-41260ee1396d
{
"connectivityType": "ShareableCloud",
"displayName": "ContosoCloudConnection"
}
Sample response
{
"id": "fa968eee-8075-48f6-8c6d-41260ee1396d",
"displayName": "ContosoCloudConnection",
"connectivityType": "ShareableCloud",
"connectionDetails": {
"type": "SQL",
"path": "contoso.database.windows.net;networks"
},
"privacyLevel": "Public",
"credentialDetails": {
"credentialType": "Basic",
"singleSignOnType": "None",
"connectionEncryption": "NotEncrypted",
"skipTestConnection": true
}
}
Virtual network gateway example
Sample request
PATCH https://api.fabric.microsoft.com/v1/connections/6b571614-2e98-4bfd-b9ed-1cb8d3ffc396
{
"connectivityType": "VirtualNetworkGateway",
"displayName": "ContosoMarketingVirtualNetworkGatewayConnection",
"privacyLevel": "Organizational",
"credentialDetails": {
"singleSignOnType": "None"
}
}
Sample response
{
"id": "6b571614-2e98-4bfd-b9ed-1cb8d3ffc396",
"displayName": "ContosoMarketingVirtualNetworkGatewayConnection",
"gatewayId": "befccff4-3ee6-40d7-b8f1-a0a9fd684a85",
"connectivityType": "VirtualNetworkGateway",
"connectionDetails": {
"type": "SQL",
"path": "contoso.database.windows.net;marketing"
},
"privacyLevel": "Organizational",
"credentialDetails": {
"credentialType": "Basic",
"singleSignOnType": "None",
"connectionEncryption": "NotEncrypted",
"skipTestConnection": false
}
}
Definitions
Name | Description |
---|---|
Anonymous |
Credentials for Anonymous CredentialType. |
Basic |
Credentials for Basic CredentialType. |
Connection |
The connection encryption type of the connection. Additional connection encryption values may be added over time. |
Connectivity |
The connectivity type of the connection. Additional connectivity types may be added over time. |
Credential |
The credential type of the connection. Additional credential types may be added over time. |
Error |
The error related resource details object. |
Error |
The error response. |
Error |
The error response details. |
Key |
Credentials for Key CredentialType. |
List |
The connection details output for list operations. |
List |
The credential details returned when fetching a connection. |
On |
A gateway ID and its encrypted serialized credentials. |
On |
A connection that connects through on-premises data gateway. |
On |
Credentials for authenticating through an on-premises gateway. |
On |
A connection that connects through a personal on-premises data gateway. |
On |
Credentials for authenticating through an on-premises gateway (personal mode). |
Personal |
A connection that connects through the cloud and cannot be shared. |
Privacy |
The privacy level setting of the connection. Additional privacy levels may be added over time. |
Service |
Credentials for ServicePrincipal CredentialType. |
Shareable |
A connection that connects through the cloud. |
Shared |
Credentials for SharedAccessSignature CredentialType. |
Single |
The single sign-on type of the connection. Additional single sign on types may be added over time. |
Update |
The credential details input for updating a connection. |
Update |
|
Update |
The credential details input for updating an on-premises gateway connection. |
Update |
|
Update |
The credential details input for updating an on-premises gateway connection. |
Update |
|
Update |
|
Update |
|
Virtual |
A connection that connects through a virtual network data gateway. |
Windows |
Credentials for Windows CredentialType. |
Windows |
Credentials for WindowsWithoutImpersonation CredentialType. |
Workspace |
Credentials for WorkspaceIdentity CredentialType. |
AnonymousCredentials
Credentials for Anonymous CredentialType.
Name | Type | Description |
---|---|---|
credentialType |
string:
Anonymous |
The credential type of the connection. |
BasicCredentials
Credentials for Basic CredentialType.
Name | Type | Description |
---|---|---|
credentialType |
string:
Basic |
The credential type of the connection. |
password |
string |
The password. |
username |
string |
The username. |
ConnectionEncryption
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
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
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
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
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 |
List of additional error details. |
|
relatedResource |
The error related resource details. |
|
requestId |
string |
ID of the request associated with the error. |
ErrorResponseDetails
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 |
The error related resource details. |
KeyCredentials
Credentials for Key CredentialType.
Name | Type | Description |
---|---|---|
credentialType |
string:
Key |
The credential type of the connection. |
key |
string |
The key. |
ListConnectionDetails
The connection details output for list operations.
Name | Type | Description |
---|---|---|
path |
string |
The path of the connection. |
type |
string |
The type of the connection. |
ListCredentialDetails
The credential details returned when fetching a connection.
Name | Type | Description |
---|---|---|
connectionEncryption |
The connection encryption setting that is used during the test connection. |
|
credentialType |
The credential type of the connection. |
|
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. |
OnPremisesCredentialEntry
A gateway ID and its encrypted serialized credentials.
Name | Type | Description |
---|---|---|
encryptedCredentials |
string |
The encrypted serialized .json of the list of name value pairs. Name is a credential name and value is a credential value. Encryption is performed using the Rivest-Shamir-Adleman (RSA) encryption algorithm with the on-premises gateway member's public key. |
gatewayId |
string (uuid) |
The object ID of the gateway. |
OnPremisesGatewayConnection
A connection that connects through on-premises data gateway.
Name | Type | Description |
---|---|---|
connectionDetails |
The connection details of the connection. |
|
connectivityType |
string:
On |
The connectivity type of the connection. |
credentialDetails |
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 |
The privacy level of the connection. |
OnPremisesGatewayCredentials
Credentials for authenticating through an on-premises gateway.
Name | Type | Description |
---|---|---|
credentialType |
The credential type of the connection. |
|
values |
The credential payload to send to the on-premises gateway. |
OnPremisesGatewayPersonalConnection
A connection that connects through a personal on-premises data gateway.
Name | Type | Description |
---|---|---|
connectionDetails |
The connection details of the connection. |
|
connectivityType |
string:
On |
The connectivity type of the connection. |
credentialDetails |
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 |
The privacy level of the connection. |
OnPremisesGatewayPersonalCredentials
Credentials for authenticating through an on-premises gateway (personal mode).
Name | Type | Description |
---|---|---|
credentialType |
The credential type of the connection. |
|
encryptedCredentials |
string |
The encrypted serialized .json of the list of name value pairs. Name is a credential name and value is a credential value. Encryption is performed using the Rivest-Shamir-Adleman (RSA) encryption algorithm with the on-premises gateway's public key. |
PersonalCloudConnection
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 |
The connection details of the connection. |
|
connectivityType |
string:
Personal |
The connectivity type of the connection. |
credentialDetails |
The credential details of the connection. |
|
displayName |
string |
The display name of the connection. |
id |
string (uuid) |
The object ID of the connection. |
privacyLevel |
The privacy level of the connection. |
PrivacyLevel
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. |
ServicePrincipalCredentials
Credentials for ServicePrincipal CredentialType.
Name | Type | Description |
---|---|---|
credentialType |
string:
Service |
The credential type of the connection. |
servicePrincipalClientId |
string (uuid) |
The client ID of the service principal. |
servicePrincipalSecret |
string |
The secret of the service principal. |
tenantId |
string (uuid) |
The tenant ID of the service principal. |
ShareableCloudConnection
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 |
The connection details of the connection. |
|
connectivityType |
string:
Shareable |
The connectivity type of the connection. |
credentialDetails |
The credential details of the connection. |
|
displayName |
string |
The display name of the connection. |
id |
string (uuid) |
The object ID of the connection. |
privacyLevel |
The privacy level of the connection. |
SharedAccessSignatureCredentials
Credentials for SharedAccessSignature CredentialType.
Name | Type | Description |
---|---|---|
credentialType |
string:
Shared |
The credential type of the connection. |
token |
string |
The token. |
SingleSignOnType
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. |
UpdateCredentialDetails
The credential details input for updating a connection.
Name | Type | Description |
---|---|---|
connectionEncryption |
The connection encryption setting that is used during the test connection. |
|
credentials | Credentials: |
The credentials of the connection. |
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. |
UpdateOnPremisesGatewayConnectionRequest
Name | Type | Description |
---|---|---|
connectivityType |
string:
On |
The connectivity type of the connection. |
credentialDetails |
The credential details of the connection. |
|
displayName |
string |
The display name of the connection. Maximum length is 200 characters. |
privacyLevel |
The privacy level of the connection. |
UpdateOnPremisesGatewayCredentialDetails
The credential details input for updating an on-premises gateway connection.
Name | Type | Description |
---|---|---|
connectionEncryption |
The connection encryption setting that is used during the test connection. |
|
credentials |
The credentials of the connection. |
|
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. |
UpdateOnPremisesGatewayPersonalConnectionRequest
Name | Type | Description |
---|---|---|
connectivityType |
string:
On |
The connectivity type of the connection. |
credentialDetails |
The credential details of the connection. |
|
privacyLevel |
The privacy level of the connection. |
UpdateOnPremisesGatewayPersonalCredentialDetails
The credential details input for updating an on-premises gateway connection.
Name | Type | Description |
---|---|---|
connectionEncryption |
The connection encryption setting that is used during the test connection. |
|
credentials |
The credentials of the connection. |
|
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. |
UpdatePersonalCloudConnectionRequest
Name | Type | Description |
---|---|---|
allowConnectionUsageInGateway |
boolean |
Allow this connection to be utilized with either on-premises data gateways or VNet data gateways. |
connectivityType |
string:
Personal |
The connectivity type of the connection. |
credentialDetails |
The credential details of the connection. |
|
privacyLevel |
The privacy level of the connection. |
UpdateShareableCloudConnectionRequest
Name | Type | Description |
---|---|---|
allowConnectionUsageInGateway |
boolean |
Allow this connection to be utilized with either on-premises data gateways or VNet data gateways. |
connectivityType |
string:
Shareable |
The connectivity type of the connection. |
credentialDetails |
The credential details of the connection. |
|
displayName |
string |
The display name of the connection. Maximum length is 200 characters. |
privacyLevel |
The privacy level of the connection. |
UpdateVirtualNetworkGatewayConnectionRequest
Name | Type | Description |
---|---|---|
connectivityType |
string:
Virtual |
The connectivity type of the connection. |
credentialDetails |
The credential details of the connection. |
|
displayName |
string |
The display name of the connection. Maximum length is 200 characters. |
privacyLevel |
The privacy level of the connection. |
VirtualNetworkGatewayConnection
A connection that connects through a virtual network data gateway.
Name | Type | Description |
---|---|---|
connectionDetails |
The connection details of the connection. |
|
connectivityType |
string:
Virtual |
The connectivity type of the connection. |
credentialDetails |
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 |
The privacy level of the connection. |
WindowsCredentials
Credentials for Windows CredentialType.
Name | Type | Description |
---|---|---|
credentialType |
string:
Windows |
The credential type of the connection. |
password |
string |
The password. |
username |
string |
The username. |
WindowsWithoutImpersonationCredentials
Credentials for WindowsWithoutImpersonation CredentialType.
Name | Type | Description |
---|---|---|
credentialType |
string:
Windows |
The credential type of the connection. |
WorkspaceIdentityCredentials
Credentials for WorkspaceIdentity CredentialType.
Name | Type | Description |
---|---|---|
credentialType |
string:
Workspace |
The credential type of the connection. |