cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vliet_pbi
Advocate II
Advocate II

SQL Server database connect hangs

When I try to connect to a SQL Server database with SQL username and password, the spinner after connect spins for more than 10 minutes and the action does not complete. If I connect to the same database with the same credentials using SQL Server Management Studio, I get an instant connection and I can see all tables and views in the database with their columns. What is wrong with Power BI Desktop? I have already tried a repair, running Power Bi Desktop as administrator, removing and adding the data source, removing the credentials, prefixing the server with tcp: but nothing helps. Any ideas?

1 ACCEPTED SOLUTION

Hi, thanks for the reply. I tried to query [INFORMATION_SCHEMA].[COLUMNS] in SSMS shortly after posting this issue on the forum and got a lock time-out; it might have been caused by a simultaneous complete refresh of the warehouse database while I was trying to access that database. Next time I will first query this view before posting a Power BI issue, to make sure this meta-data is indeed available. I guess the object explorer of SSMS does not query the meta-data of the contained tables and views all at once (like Power BI does?), but probably just their names. I will try to access the database from Power BI today during office hours to see if it is indeed just a transient lock time-out on the SQL Server meta-data; if the issue remains I will post a new 'cry for help' on this forum, but with more detailed information.

View solution in original post

3 REPLIES 3
v-ljerr-msft
Microsoft
Microsoft

Hi @vliet_pbi,

 

I just verified that I can use the latest version(2.47.4766.801 64-bit (June 2017)) of Power BI Desktop to connect SQL Server database without any issue.

 

As we cannot reproduce the issue and there is no any error message for further troubleshooting, I would suggest you create a support ticket on Power BI Support page for better assistance on this issue. Smiley Happy

 

Regards

Hi, thanks for the reply. I tried to query [INFORMATION_SCHEMA].[COLUMNS] in SSMS shortly after posting this issue on the forum and got a lock time-out; it might have been caused by a simultaneous complete refresh of the warehouse database while I was trying to access that database. Next time I will first query this view before posting a Power BI issue, to make sure this meta-data is indeed available. I guess the object explorer of SSMS does not query the meta-data of the contained tables and views all at once (like Power BI does?), but probably just their names. I will try to access the database from Power BI today during office hours to see if it is indeed just a transient lock time-out on the SQL Server meta-data; if the issue remains I will post a new 'cry for help' on this forum, but with more detailed information.

dkay84_PowerBI
Microsoft
Microsoft

Are you attempting a Direct Query or Import?

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors