Forum Discussion
Solved
SQL Server connection: Failed to update data source credentials
Good day, I receive the "Failed to update data source credentials" when trying to sign into my SQL Server database. I have tested the credentials in PowerBI Desktop (and the refresh is working...
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?
