Forum Discussion
Refresh timeout
Hi
What can I do to prevent timeouts when I refresh in Power BI Desktop (See picture below). It happens after 40-50 min.
The data source is an Azure SQL Database.
7 Replies
- parry2kSuper User
Anonymous do you get the preview of this table in power query?
- AnonymousNot applicable
Yes i do and sometimes i can refresh, but other times i get the error message.
- parry2kSuper User
Anonymous that's why I didn't suggest to check the timeout option because I saw you are using Azure Table. I believe it has something to do with your internal connectivity and latency. The Azure data center is in the same region where you are trying to access these tables, maybe it is a latency issue.
Overall it looks like a network problem than anything else.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
- amitchandakSuper User
Anonymous , As per these topics you have increase refresh timeout and try
https://community.powerbi.com/t5/Service/Power-BI-Service-Refresh-Issue-Azure-SQL-Server/td-p/722114
- AnonymousNot applicable
hi amitchandak
It should have said "Azure table storage"
Because it seems easy to increase the timeout time with sql, but not with the table storage databases.