Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

data source not able to connect

 

hello,

 

I need a little guidance,

i am trying to add a data source (SQL Server) to a newly installed gateway and I keep getting this error

error.JPG

I have searched in this community and online and most solutions are usually to update the gateway. but in my case, the gateway is up to date since it was downloaded today.

 

please how do I solve this?

1 ACCEPTED SOLUTION
nickyvv
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous,

What exactly do the details say if you click on Show details?

If it's an Azure SQL DB, you might have to open the firewall for the IP-address (or range) of the gateway server to reach that DB. Otherwise it might be bad credentials, but that's hard to guess from this point.



Did I answer your question? Mark my post as a solution!

Blog: nickyvv.com | @NickyvV


View solution in original post

2 REPLIES 2
nickyvv
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous,

What exactly do the details say if you click on Show details?

If it's an Azure SQL DB, you might have to open the firewall for the IP-address (or range) of the gateway server to reach that DB. Otherwise it might be bad credentials, but that's hard to guess from this point.



Did I answer your question? Mark my post as a solution!

Blog: nickyvv.com | @NickyvV


Anonymous
Not applicable

Thank you.

 

it was bad credentials.

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.