Forum Discussion

jessicabonicenh's avatar
jessicabonicenh
Regular Visitor
3 years ago
Solved

ERROR 400 - Credentials (SQL)

I am using a personal data gateway but I'm not able to refresh the data, because is showing invaild credetials and error 400. Does anyone know how to fix it? 

 

PS: the user and password is correct

 

 

 

 

Need Help
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    3 years ago

    Hi jessicabonicenh ,

     

    Since you have tried all the auth possibilities and the error persists, I suggest that you can check if the personal gateway you used is the latest version. If the gateway version is out of date, many problems arise.

    And you can check as described below:

    1, The username and password used to log in to the data source are not up-to-date. In Power BI, go to the refresh settings for your dataset. In Manage Data Sources, select Edit Credentials to update the credentials for the data source.

    2, If one of the sources authenticates using OAuth, the combination of cloud and on-premises sources cannot be refreshed in the gateway (personal mode) in a single query. An example of this problem is the integration of CRM Online with an on-premises instance of SQL Server. Blending will fail to refresh because CRM Online requires OAuth.

     

    Please refer to the following documents.

    Troubleshooting Power BI Gateway (Personal Mode) - Power BI | Microsoft Learn

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    jessicabonicenh Well the first guess would be that it doesn't support Basic auth. So does this work fine from Power BI Desktop and only have an issue with the Personal Gateway? Is the Personal Gateway running on the same computer that you run Desktop on?

    • jessicabonicenh's avatar
      jessicabonicenh
      Regular Visitor
      3 years ago

      Hello! Thanks for the reply

      Well, I already tried all the auth possibilities and the error persists. And the problem only occour on       the PBI Service.

       

      I'm not in the same computer that run the gateway, buttt i already tried in the same pc and it shows the same error. 

  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    Community Support
    3 years ago

    Hi jessicabonicenh ,

     

    Since you have tried all the auth possibilities and the error persists, I suggest that you can check if the personal gateway you used is the latest version. If the gateway version is out of date, many problems arise.

    And you can check as described below:

    1, The username and password used to log in to the data source are not up-to-date. In Power BI, go to the refresh settings for your dataset. In Manage Data Sources, select Edit Credentials to update the credentials for the data source.

    2, If one of the sources authenticates using OAuth, the combination of cloud and on-premises sources cannot be refreshed in the gateway (personal mode) in a single query. An example of this problem is the integration of CRM Online with an on-premises instance of SQL Server. Blending will fail to refresh because CRM Online requires OAuth.

     

    Please refer to the following documents.

    Troubleshooting Power BI Gateway (Personal Mode) - Power BI | Microsoft Learn

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.