Forum Discussion

Charline_74's avatar
Charline_74
Icon for Resolver I rankResolver I
27 days ago
Solved

FABRIC REST API Connections - Create Connection

Does anyone know how to run this API via a PowerShell script to create a SQL Server cloud connection for a semantic model using Service Principal authentication? Here's what I have so far: Invoke-P...
Data Science
Experiment
  • Charline_74's avatar
    Charline_74
    19 days ago

    Hi 

    $body = @{
        connectivityType = "ShareableCloud"
        displayName = "SQL Server Connection"
        connectionDetails = @{
            type = "SQL"
            creationMethod = "SQL"
            parameters = @(
                @{ dataType = "Text"; name = "server"; value = "XXX" },
                @{ dataType = "Text"; name = "database"; value = "XXX" }
            )
        }
        privacyLevel = "Organizational"
        credentialDetails = @{
            singleSignOnType = "None"
            connectionEncryption = "Encrypted"
            skipTestConnection = $false
            credentials = @{
                credentialType = "ServicePrincipal"
                tenantId = "XXX"
                servicePrincipalClientId = "XXX"
                servicePrincipalSecret = "XXX"
            }
        }
    } | ConvertTo-Json -Depth 10

Kagiyama_yutaka's avatar
Kagiyama_yutaka
Icon for Skilled Sharer rankSkilled Sharer
21 days ago

I think there are two separate calls here. POST /v1/connections creates the SQL cloud connection; binding it to the semantic model uses bindConnection. For SP auth, put credentialType, tenantId, servicePrincipalClientId, and servicePrincipalSecret under credentialDetails.credentials. One catch: the bindConnection caller needs to own the semantic model.