Forum Discussion

hassanwasef's avatar
hassanwasef
Frequent Visitor
9 years ago

Power BI Desktop Timeout expired.

  Hello, I have an issue while trying to refresh data from datasource in power bi desktop, the error "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. Thi...
Show and Tell
hassanwasef's avatar
hassanwasef
Frequent Visitor
9 years ago

unfortunately, it didn't work.. I guess the problem is away from the other apps that use the DB. 
When i tried to make a new pbix with just one visual that connects to the same db. it worked fine.. 
on the other hand when i run the pbix with many visuals and reports. it returns the error mentioned. 
so it is power bi issue i believe.. is it possible that power bi opens a sql server pool for each report or visual ? 

alaeddin14's avatar
alaeddin14
Icon for Helper I rankHelper I
9 years ago

Have you tried to increase the "Command timeout in minutes" ? 

 

 

Power bi definitely doesn't run the query again for each graph, but when it comes to a remote database, the connections quality also plays a role. 

 

Cheers,

Alaeddin