Power BI Rest API via Powershell

[powerbi_jenhen]

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

    }

[powerbi_jenhen · Accepted solution]

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

        }

    })

[lbendlin]

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

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

[powerbi_jenhen]

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

        }

    }

"@