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...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I have the same problem.

 

I publish our "Golden Data Set" to a workspace.

I am able to update the report Data Set Parameters "dbName" and "dbServer" using the API.

 

This enables the Gateway, but the "Map To" field does not select the server by default.

You have to manually select the server after the dbName and dbServer fields are updated.

 

I need a way to select the Data Source in the Map To dropdown using the API.

 

  • 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