topic Re: Power BI Rest API via Powershell in Developer

Power BI Rest API via Powershell

powerbi_jenhen — Wed, 27 Mar 2024 11:31:52 GMT

Hi,

I have the below $Body variable to use within my API Invoke command, how can I exit the single quotes to reference my $server and $database variables? I currently receive the error: "DMTS_UnsupportedConnectionStringError". I've tried to add single quotes to exit but this triggers an unexpected token:

$Body = @{

"datasourceType"="SQL"

"connectionDetails"='{"server":$server,"database":$database}'

"datasourceName"=$gatewaySourceName

}

Re: Power BI Rest API via Powershell

lbendlin — Wed, 27 Mar 2024 21:30:56 GMT

$Body = @" { "datasourceType":"SQL", "connectionDetails":'{"server":$server,"database":$database}', "datasourceName":$gatewaySourceName } "@@

note that the last line should be "@ . Can't get rid of the second @

Re: Power BI Rest API via Powershell

powerbi_jenhen — Thu, 28 Mar 2024 09:31:04 GMT

Thanks! I actually have further details in my $Body so would the below be the correct syntax? I'm getting a "BadRequest" on my Invoke:

$Body = @"

{

"datasourceType":"SQL",

"connectionDetails":'{"server":$server,"database":$database}',

"datasourceName":$sourceName,

"credentialDetails":{

"credentialType":$credentialDetails.credentialType,

"credentials":$credentialDetails.credentials,

"encryptedConnection":$credentialDetails.encryptedConnection,

"encryptionAlgorithm":$credentialDetails.encryptionAlgorithm,

"privacyLevel":$credentialDetails.privacyLevel

}

Re: Power BI Rest API via Powershell

powerbi_jenhen — Thu, 28 Mar 2024 12:22:26 GMT

The issue was my server variable required "\\" not "\". Code that worked for me:

$Body = ConvertTo-Json -Depth 4 -InputObject $(@{

dataSourceType = "Sql"

connectionDetails = '{"server":"'+$server.Replace("\","\\")+'","database":"'+$database+'"}'

datasourceName = $sourceName

credentialDetails = @{

credentialType = $credentialDetails.credentialType

credentials = $credentialDetails.credentials

encryptedConnection = $credentialDetails.encryptedConnection

encryptionAlgorithm = $credentialDetails.encryptionAlgorithm

privacyLevel = $credentialDetails.privacyLevel

}

})