Forum Discussion

clehnert's avatar
clehnert
Frequent Visitor
5 months ago

REST API BindToGateway returning 200OK but not using passed data source?

Hi all,   For a couple of years now I've been working on a Power BI Embedded solution to give customers access to a handful of premade dashboards and give them the ability to make new reports based...
Need Help
v-saisrao-msft's avatar
v-saisrao-msft
Community Support
5 months ago

Hi clehnert,

The BindToGateway API returning a 200 OK status means the request was accepted. However, successful binding requires that the dataset’s server and database names match those in the gateway data source definition. If the server naming formats differ, the gateway association may fail. Make sure the service principal is included as a data source user, and if you’re using a gateway cluster, provide the primary gateway ID. To check the binding status, use the Get Datasources In Group API.

Datasets - Bind To Gateway In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Add or remove a gateway data source - Power BI | Microsoft Learn

 

Thank you.

 

  • clehnert's avatar
    clehnert
    Frequent Visitor
    5 months ago

    We are doing all of the above, with the exception of the fact that on some of the datasources, the casing of the database name in the parameters is different from the casing of the database name in the connection details. On one of my test workspaces I've been able to reliably rebind the datasets regardless of the casing of the database name in the dataset parameters vs the datasource connection details, but in the other test database with the same scenario I'm reliably unable to properly rebind.

     

    If this is a case of gateway association potentially failing if the cases don't match, then is there a way to update the connection details of a datasource after it has been created? The only endpoint I can find that looks like it can modify an existing datasource is Gateways - Update Datasource, and that looks like it's specifically for updating the credential details, not connection details.

     

    Please let me know your thoughts on this, thank you!

    • v-saisrao-msft's avatar
      v-saisrao-msft
      Community Support
      5 months ago

      Hi clehnert,

      If you’ve already verified that the dataset parameters and gateway datasource connection details are an exact match including case and formatting but the BindToGateway API still returns a 200 OK without updating the association, this issue may need to be checked on the backend. I recommend opening a Microsoft support ticket for further investigation.

      You can submit a support request here:

      Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn

       

      Thank you.