Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Status 400 Error when setting up an SQL Gateway on Power Bi

Hi I am getting the below message when creating a new connection to an on prem SQL database via Power BI. I'm using the same credentials and setup that work on another connection to the same on prem sql server but on a different sql database. Unfortunately I can't find any difference or see any logs to give me a clue as to why are where the error is coming from. Any help would be appreciated. The credential setup is basic username and password with organisational privacy level.

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    So in the end it was the authentication method on 365 needed to be identical to what i was using on Power BI Desktop. So simple when someone points it out !!!!

7 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    3 years ago

    Hi Anonymous 

     

    Could you make sure that you are running the latest version of the Gateway software?

     

    Also can you confirm that the user account has got access to the SQL Database?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi GilbertQ 

      Running the latest version of the Data Gateway Software 3000.174.13 (May 2023).

      The username used has full access to the database. Just to be sure I logged in to the on Prem SQL Server with the same username and was able to run queries on the SQL Database.

      • GilbertQ's avatar
        GilbertQ
        Super User
        3 years ago

        Hi Anonymous 

         

        Could it be possible that the Gateway server cannot connect to the Internet via https?