Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI Gateway Issue

  Description: We are encountering a recurring issue with our Power BI gateway. The error message we're receiving is: Data source error: {"error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderOpen...
Need Help
crhoades538's avatar
crhoades538
Frequent Visitor
2 years ago

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.