Power BI Gateway Issue

[Anonymous]

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_AdoNetProviderOpenConnectionTimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderOpenConnectionTimeoutError","parameters":{},"details":[]}}} Table: GPS ALERT.

Background: This issue intermittently affects data source updates.

Request for Assistance: We need help identifying the cause and resolving this issue. The error message is not very informative, and we're looking for guidance on diagnosing and fixing the problem.

[user518520]

 we are having the same issue as of this morning 01-Dec-23.  Already tried restarting gateway but with no luck... Anything that has changed on the power BI service side that we should cater for

[mcaraballo]

Same situation here. We tried restarting the gateway, but still getting this error. 

[BIProcessVIV]

I had the same error and It happens very frequently, but in the following auto refresh, the data refreshed successfully. I had updated the on-premises data gateway and I restarted the data gateway, but it keeps happening. Please Help us.

[v-yangliu-msft]

Hi  @Anonymous ,

Can you provide us with the following information so we can better assist you:

1. Are you using a personal gateway or an on-premises data gateway?

2. What version of Power BI Gateway are you currently using?

3. Have you made any recent changes to your data source or gateway configuration?

You can check the following:

1. Is your gateway up to date, if not, you can download the latest version of the gateway from the link below:

Update an on-premises data gateway | Microsoft Learn

2. Check network connectivity: Ensure that there are no network issues or firewall restrictions preventing the gateway from connecting to the data source.

3. Verify data source credentials: Make sure that the credentials used to connect to the data source are correct and have not expired. You can update the credentials in the gateway settings.

You can also check common gateway related errors and solutions in the link below:

Troubleshoot gateways - Power BI | Microsoft Learn

This is the related document, you can view this content:

Solved: English translation of this error: DM_GWPipeline_G... - Microsoft Fabric Community

Solved: Gateway Timeout Error - Microsoft Fabric Community

Solved: DM_GWPipeline_Gateway_TimeoutError - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Airat58876]

We use a personal mod, the latest version of the gateway is installed. This error has been popping up for the last few days. The sources are different, there is a report in which the data is SQL via ODBC, there is a report in which the data is directly from an Excel file. There is an error in both reports

[chenchen]

I had the same error, but in the following auto refresh, the data refreshed successfully, I had updated the data gateway, and restarted the data gateway, but it keep showing the data gateway error occasionally.

[AnthonyJoseph]

@Anonymous can you try restating gateway? It should work most of the time.