Forum Discussion
Getting “DM_GWPipeline_Gateway_AdoNetProviderOpenConnectionTimeoutError” During Dataset Refresh
Hi,
I’m encountering the following error while refreshing my dataset in Power BI Service:
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderOpenConnectionTimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderOpenConnectionTimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}}
The dataset refresh works fine when done manually in Power BI Desktop or Power BI Service, but it fails during the scheduled refresh with this timeout error.
What could cause this connection timeout, and how can I fix it?
Thank you.
On all gateway VMs attempt to connect to the data source and confirm that you can successfully retrieve data. Most of the time there are firewall settings that prevent a connection.
Hi Mahendra_k,
Thank you for posting your query in Microsoft Fabric Community Forum. Also, thanks to lbendlin , for those inputs on this thread.
Please check once if you are able to connect to the data source directly from all gateway machines. Also make sure there are no firewall or network rules blocking the gateway from reaching the data source. It’s a good idea to re-enter the credentials for your data source in Power BI Service and confirm they are valid.Sometimes the gateway service might be stopped or running on an older version, so please verify that it’s up to date and running fine. If your query is taking longer time to load data, try to optimize it or increase the timeout settings.
If the refresh still fails after these checks, please share the detailed error from the refresh history and the gateway log details, so we can help you further.
please go through with the below document hope it may resolve your Issue:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshootHope this helps if you have any queries we are happy to assist you further.
Best Regards,
Harshitha.
4 Replies
On all gateway VMs attempt to connect to the data source and confirm that you can successfully retrieve data. Most of the time there are firewall settings that prevent a connection.
Hi Mahendra_k,
Thank you for posting your query in Microsoft Fabric Community Forum. Also, thanks to lbendlin , for those inputs on this thread.
Please check once if you are able to connect to the data source directly from all gateway machines. Also make sure there are no firewall or network rules blocking the gateway from reaching the data source. It’s a good idea to re-enter the credentials for your data source in Power BI Service and confirm they are valid.Sometimes the gateway service might be stopped or running on an older version, so please verify that it’s up to date and running fine. If your query is taking longer time to load data, try to optimize it or increase the timeout settings.
If the refresh still fails after these checks, please share the detailed error from the refresh history and the gateway log details, so we can help you further.
please go through with the below document hope it may resolve your Issue:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshootHope this helps if you have any queries we are happy to assist you further.
Best Regards,
Harshitha.Hi Mahendra_k,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Community Support Team.Hi Mahendra_k,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
community Support team.