Power BI personal gateway error

[idanco]

I have an Excel Powerpivot model uploaded to Power BI

* Personal Gateway is installed and running

* i have one Power Query source - Sql Server , i use server login

* when i type the login details on the "Manage data sources" section - i get "Login Failed" 

Even though this is the correct login.

I had this issue in several cases, Did someone manage to refresh a data model using the personal gateway ? 

Any idea how to resolve this ? 

[Greg_Deckler]

I am seeing the same thing on my gateway and, worse, my SQL Server is local. I tried both Windows and Basic authentication and both failed even though I can sign on to SQL Server Management Studio with both of those credentials successfully.

I sent a frown.