Forum Discussion
SQL Server connection: Failed to update data source credentials
with a public IP you could avoid the gateway but the SQL Server instance port must be opened as well, maybe it's been closed.
please note having a SQL Server opened on the public internet is not a best practice.
Is it on-prem or cloud database ?
Hello Cookistador
It is an on-prem database.
Did you set up a gateway ?
If yes, is it a personnal or a standard gateway ?
No, I did not set up a gateway.
I used the SQL Server data source and just entered credentials.
Get Data > SQL Server.Should I setup a gateway instead? Will this be a better solution for loading the data into PBI?
Hello,
You have to use a gateway to expose your on premise data on the cloud
If you want, you can install a local gateway on your local machine to performed some testsBut for organization, you have to deploy it on a dedicated machine