Forum Discussion
Power BI Desktop Timeout expired.
Hi hassanwasef,
I can't reproduce your issue, it works on my side. I think the issue may related to other applications which connect to azure sql. You can check at the connect pool and try to release resources.
Regards,
Xiaoxin Sheng
Hi, Anonymous this might be the case, I will check all the apps that use the db. Thank you.
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