Forum Discussion

udione's avatar
udione
Helper I
1 year ago

Create Cloud Connection via Rest Api

I'd like to create Cloud Connection to my lakehouse via REST api. The feature I'm referring to is described here https://learn.microsoft.com/en-us/power-bi/connect-data/service-create-share-cloud-dat...
Need Help
sdemei's avatar
sdemei
Advocate I
1 year ago

I am having the same issue, did someone manage to get a solution for this? 

  • udione's avatar
    udione
    Helper I
    1 year ago

    Post json in this format:

     

    {
    "connectionDetails": {
    "type": "SQL",
    "creationMethod": "SQL",
    "parameters": [
    {
    "dataType": "Text",
    "name": "server",
    "value": "Lakehouse CONNECTIONSTRING"
    },
    {
    "dataType": "Text",
    "name": "database",
    "value": "LAKEHOUSENAME"
    }
    ]
    },
    "connectivityType": "ShareableCloud",
    "credentialDetails": {
    "singleSignOnType": "None",
    "connectionEncryption": "NotEncrypted",
    "skipTestConnection": false,
    "credentials": {
    "credentialType": "ServicePrincipal",
    "servicePrincipalClientId": "CLIENTID",
    "tenantId": "TENANTID",
    "servicePrincipalSecret": "SECRET"
    }
    },
    "displayName": "CONNECTIONNAME",
    "privacyLevel": "Organizational"
    }

     

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