Forum Discussion
Power BI Gateway Issue
We have been experiencing the same issue, DM_GWPipeline_Gateway_AdoNetProviderOpenConnectionTimeoutError. We are running a cluster gateway with 3 computers running on the on premise gateway. Issue started on 1-16 out of the blue. It appears when multiple datasets are using the same dataflows but this is occurring on excel files and SharePoint. Reached out to Microsoft to create a ticket... they were not helpful. They just said there is a connection problem. Any advice on how to correct this issue would be helpful.
This is also an intermittent issue for refreshes... cannot determine the exact cause of why sometimes it works and sometimes it doesn't. This is effecting multiple dataflow/dataset refreshes not just one. So, can only assume there is not an issue contained within one model.
Just a follow up from our end. Have been working with MS for a few weeks. Installing agents on our HA gateway servers which are pinging MS sites every 5 seconds and also capturing logs and providing MS with a bunch of logs trying to work out the problem. Will update soon with any resolution.