Forum Discussion
Syndicate_Admin
3 years agoAdministrator
Error en Power Bi
Good day team, I have a problem with power BI, My file does not update me in automatic and throws me the following error. Could I support how I could solve it or what is the error? Data source e...
- 3 years ago
Hi Syndicate_Admin ,
This error means that the query took too long to execute and the gateway connection was closed before it finished.
There are some possible solutions that you can try to fix this error:
- Increase the CommandTimeout and the ConnectionTimeout parameters in your Power Query settings. These parameters control how long the query can run before it is terminated. The default value for CommandTimeout is 10 minutes and the default value for ConnectionTimeout is driver-dependent1. You can increase them to a longer duration, such as 2 hours, to allow more time for the query to complete. You can find the steps to modify these parameters in this document.
- Reduce the size of your data or use incremental refresh. If your data is too large or complex, it may take longer to load and process. You can try to filter out unnecessary columns or rows, or use incremental refresh to only load the data that has changed since the last refresh. This can help improve the performance and reduce the load on the gateway. You can learn more about incremental refresh in this article.
- Check your network connectivity and firewall settings. Sometimes, the timeout error may be caused by network issues or firewall blocking the gateway connection. You can try to test your network speed and stability, and make sure that your firewall allows the gateway to communicate with the data source and the Power BI service.
- Or you can try to update the gateway to latest version and restart the gateway, sometimes restart the gateway could solve the problem.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Syndicate_Admin
3 years agoAdministrator
A question how can I increase the timeout setting?