Forum Discussion
Gateway credentials different to Desktop
It should work, but like you are asking the best way would be having a gateway with standard mode in a remote server that is on 24 hours a day to help you schedule refresh at any time.
The configuration of that gateway should work. You can use this post as reference but the pictures might not be up to date
https://blog.ladataweb.com.ar/post/189013278236/powerbigateway-configurar-una-actualización
I hope that fixes it
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 🙂
It should work, but like you are asking the best way would be having a gateway with standard mode in a remote server that is on 24 hours a day to help you schedule refresh at any time.
The configuration of that gateway should work. You can use this post as reference but the pictures might not be up to date
https://blog.ladataweb.com.ar/post/189013278236/powerbigateway-configurar-una-actualización
I hope that fixes it