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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sstar118
New Member

Unable to connect to SQL Server

Hi,

 

I am using the Desktop version. I am unable to connect to a Microsoft SQL Server. I do not get any error message. It just keeps spinning and spinning and never connects. Sometimes I get to the the second screen where it says to use windows credentials but then that just keeps loading. I am able to connect to this SQL sever with Tableau and Qlik but am having trouble with Power BI.

 

Any suggestions?

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

On your login screen for database engine click on 'Options' 

sql1.JPG

 

Then click on "connection properties" tab and uncheck "Encrypt connection".

 

sql2.JPG

Hope this helps.

View solution in original post

Hi there

I would discuss this with your DBA to see if they enable connections without it being encrypted.

And then from there when m you connect you can change the connection properties to not use encryption




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

Proud to be a Super User!







Power BI Blog

View solution in original post

8 REPLIES 8
GilbertQ
Super User
Super User

Hi @sstar118

 

Can you confirm that you have got the correct drivers installed to connect to SQL Server for Power BI?

 

I stand to be corrected but I do recall having to install SQL Server Management Studio.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms 





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

Proud to be a Super User!







Power BI Blog

Hi,
 
Yes I have SQL Server management studio installed and am able to access the server and database through that. Just am unable to establish a connection with power bi. As I mentioned I do not get any error it just keeps trying to connect but never does.
 
Thanks 

Hi @sstar118

 

When connecting do you use the FQDN or the Server name?





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

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ

 

I connect using the server name. I am not sure what the FQDN is.

Hi @GilbertQ

 

I let it connect for about 20 minutes and then got a message that it needed to be an encrypted connection, once I hit okay I was able to connect. Is there anyway to kick it off an an ecrypted connection so that it does not take so long to connect in the future.

 

Thanks!

Hi there

I would discuss this with your DBA to see if they enable connections without it being encrypted.

And then from there when m you connect you can change the connection properties to not use encryption




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

Proud to be a Super User!







Power BI Blog

thank you all. My issue has been resolved

Anonymous
Not applicable

On your login screen for database engine click on 'Options' 

sql1.JPG

 

Then click on "connection properties" tab and uncheck "Encrypt connection".

 

sql2.JPG

Hope this helps.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.