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
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors