Forum Discussion
Power BI Desktop Timeout expired.
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 ?
Hi hassanwasef,
>>is it possible that power bi opens a sql server pool for each report or visual ?
No, it only use one pool, it will auto release the resource after get data. (it not keep the live connection)
>>When i tried to make a new pbix with just one visual that connects to the same db. it worked fine..
Sorry for that, I also not know what will caused the issue.
Regards,
Xiaoxin Sheng
- alaeddin14
Helper I
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
