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.
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
it's the only solution working.
Power BI service is a cloud application and has no clue about your private network (where your sql server resides).
if you're not the only person in your organization using power bi it's very likely you've already a standard OPDG setup. double check with your IT depo.