Rest API / Powershell : Unable to create Datasource in Gateway (OnPremises)

[jaapinho]

Hello,

I'm using this code :

$url = "gateways/MYGateway/datasources"
$body = @{
    datasourceName    = "MYDatasource"
    datasourceType    = "SQL"
    connectionDetails = '{"server":"MYServer\\MYInstance", "database":"MYDatabase"}'
    credentialDetails = @{
        credentialType              = "Basic"
        credentials                 = "%A4O%95f%2C%F6p%...%25%15%BB3cE%04"
        encryptionAlgorithm         = "RSA-OAEP"
        useEndUserOAuth2Credentials = "False"
        }
    }
$jsbody = $body | ConvertTo-JSON
invoke-PowerBIRestMethod -Method Post -Url $url -Body $jsbody

Note  : Credentials hash is RSA-OEP crypted from :
   {
    \"credentialData\":
       [
       {\"name\":\"username\",\"value\":\"MYUsername\"},
       {\"name\":\"password\", \"value\":\"MYPassword\"}
       ]
   }

This code returns :

    VERBOSE: Request Uri:
    https://api.powerbi.com/v1.0/myorg/gateways/MYGateway/datasources
    VERBOSE: Status Code: BadRequest (400)

I don't understand why. Can someone please help ?

[Ybam]

Hi @jaapinho ,
I want to create a datasource in my on-prem gateway but I always had a 400 error.
My code is similar to yours and I have 2 questions:

- What's your "MYInstance" ?

- How your credentials are crypted, I use for mine this script(https://endjin.com/blog/2020/12/how-to-update-credentials-for-an-on-prem-power-bi-data-source-using-...)
Thank you 

[jaapinho · Accepted solution]

Hi, MYgateway represents my gateway ID (Which i couldnt put here). But problem is solved. creds hash was miscalculated.

Thank you

[lbendlin]

there is no such thing as MyGateway. Did you mean to call Gateways - Create Datasource (Power BI Power BI REST APIs) | Microsoft Docs ?