Forum Discussion

idanco's avatar
idanco
Icon for Advocate II rankAdvocate II
11 years ago

Power BI personal gateway error

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 ? 

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    11 years ago

    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.