Forum Discussion

Petanek333's avatar
Petanek333
Icon for Helper III rankHelper III
4 years ago
Solved

Gateway credentials different to Desktop

Hi, I am trying to set up a gateway to access the SQL database so I can have a report created in Desktop in Service.  In Desktop version, my connection is configured as seen below with credentials ...
Need Help
Show and Tell
ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
4 years ago

Hi Petanek! Please try your database credentials over "basic" authentication. The basic is a name used for regular authentication of the selected source. It should work.

I hope that helps,

  • Petanek333's avatar
    Petanek333
    Icon for Helper III rankHelper III
    4 years ago

    Unfortunately this does not work. But I am not sure I am doing it right.

     

    I have an SQL database on a remote server I am connecting to. In Power BI Desktop I go simply Get Data > SQL Server > write a server name + port and database name and those credentials via authentification type Database.

    In order to load data from remote SQL server into a report published to PBI Service, I need the Data gateway, right? 

    I hoped that I can install a personal gateway on my computer and set it to connect to this remote server SQL database. But it is not working due to above mentioned credentials - the Basic authentification does not work. 

     

    May the reason be that I have to install the gateway in a standard mode directly on the remote server? Or should I be able to connect to the remote server SQL DB via Personal gateway installed on my computer? 

    Sorry if I am being a noob, I just don't feel very comfortable with those data connection things yet 🙂