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

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

jaapinho — Mon, 07 Dec 2020 11:08:07 GMT

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 ?

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

lbendlin — Mon, 25 Jan 2021 03:04:41 GMT

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

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

jaapinho — Mon, 25 Jan 2021 10:24:27 GMT

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

Thank you

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

Ybam — Thu, 11 Mar 2021 14:05:01 GMT

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-powershell.html#script)
Thank you