SQL Server connection: Failed to update data source credentials

[Chibuye_6]

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 fine on desktop) and SSMS and I am able to access the database. 

Because of this, I am not able to enable automatic refreshes which is essential for our Reports. 

Any thoughts on how to get around solving this? 

[v-sathmakuri]

Hi @Chibuye_6  ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thanks!!

[Cookistador]

Is it on-prem or cloud database ?

[Chibuye_6]

Hello @Cookistador 
It is an on-prem database. 

[Cookistador]

Did you set up a gateway ?

If yes, is it a personnal or a standard gateway ?

[Chibuye_6]

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?

[Cookistador]

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 tests

But for organization, you have to deploy it on a dedicated machine

[R1k91]

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.

[Chibuye_6]

Hello @R1k91 

We have a public IP set up with our ISP to expose the database. I am able to access it anywhere outside my private network and, it was working just fine until a few days ago. 

I will setup the gateway anyway and try to connect like that. 

[v-nmadadi-msft]

Hi @Chibuye_6 ,

Here are some resources to get you started with On-Prem data gateway
What is an on-premises data gateway? | Microsoft Learn
How to download: Install an on-premises data gateway | Microsoft Learn
Configuration in Service: Add or remove a gateway data source - Power BI | Microsoft Learn

Tutorial to refresh data from an on-premises SQL Server database: Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards

[R1k91 · Accepted solution]

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.