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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors