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 ...
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 !!!!

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi GilbertQ I think if the Gateway server could not connect to the Internet via https then all our other services would be blocked as well. However, we have another database on the same SQL Server that has no issue connecting via the Gateway to Power BI, thats the frustrating part. Not sure where I can look at logs that would possibly identify the issue.

Anonymous's avatar
Anonymous
Not applicable
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 !!!!

  • glasshalfasleep's avatar
    glasshalfasleep
    Helper I
    1 year ago

    What do you mean it has to be the same? Mine is the same and Im getting the same type of issue.