cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

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

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors