Forum Discussion

powerbi_jenhen's avatar
powerbi_jenhen
Resolver II
2 years ago
Solved

Power BI Rest API via Powershell

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_Uns...
Need Help
  • powerbi_jenhen's avatar
    powerbi_jenhen
    2 years ago

    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's avatar
lbendlin
Super User
2 years ago

 

 

 

$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's avatar
powerbi_jenhen
Resolver II
2 years ago

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
        }
    }
"@