Forum Discussion

ilav's avatar
ilav
Frequent Visitor
6 years ago

Can't select Maps To in Gateway setting via API/Powershell

Hello - I have a dataset which successfully connects to an azure DB via gateway when configured manually. However, when trying to configure the dataset via powershell, unable to select the gateway in...
mbutler71's avatar
mbutler71
Icon for Advocate I rankAdvocate I
5 years ago

Having the same issue, anyone else able to solve this?

DevOps deploys the "Report" Dataset successfully.
DevOps updates the datasource in the "Report" Dataset successfully.

The Gateway Connection in the "Report" Dataset loses it's mapping to a 'datasource' in the On-Premise Gateway.

 

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi mbutler71,

 

I was able to select the Map To field with the following:

 

# TRY TO BIND
$bindUrl = 'datasets/<ReplaceWithYourGatewayId>/Default.BindToGateway'
 
$postBindParams = @{
    gatewayObjectId = "yourGatewayId"
    datasourceObjectIds =@(
        "yourDataSourceId"
    )
} | ConvertTo-Json

write-host $postBindParams
Invoke-PowerBIRestMethod -Url $bindUrl -Method Post -Body $postBindParams -ContentType $content -Verbose