Gateway connectivity issue

[Noak]

Hi,

I'm having problems to refresh my report and need your help.

My data set is built from several data sources which connected to 2 different servers.

I added the data sources and granted premission , connection seems to be fine. (please via attached image)

I scheduale the refreshing time to 4:00AM and get Timeouts at 8AM, I dont understand the problem.

please help me.

[v-shex-msft]

Hi @Noak,

Can you please share some detail informations about this issue? I can't find some useful informations from your screenshots.

Reference:

Troubleshooting the on-premises data gateway

Tools for troubleshooting

Collecting logs from the gateway configurator

There are several logs you can collect for the gateway, and you should always start with the logs. The simplest way to collect logs after installing the gateway is through the user interface. In the On-premises data gateway user interface, select Diagnostics and then select the Export logslink near the bottom of the page, as shown in the following image.

Installer logs

Copy

%localappdata%\Temp\On-premises_data_gateway_*.log

Configuration logs

Copy

%localappdata%\Microsoft\On-premises Data Gateway\GatewayConfigurator*.log

On-premises data gateway service logs

Copy

C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises Data Gateway\Gateway*.log

Event Logs

The On-premises data gateway service event logs are present under Application and Services Logs.

Fiddler Trace

Fiddler is a free tool from Telerik that monitors HTTP traffic. You can see the back and forth with the Power BI service from the client machine. This may show errors and other related information.

Refresh History

When using the gateway for scheduled refresh, Refresh History can help you see what errors have occurred, as well as provide useful data if you should need to create a support request. You can view both scheduled, as well as on demand, refreshes. Here is how you can get to the Refresh History.

1. In the Power BI navigation pane, in Datasets, select a dataset > Open Menu > Schedule Refresh.

   

2. In Settings for... > Schedule Refresh, select Refresh History.

   

   

For additional information about troubleshooting refresh scenarios, take a look at the Troubleshooting Refresh Scenarios article.

Regards,

Xiaoxin Sheng

[Noak]

Hi @v-shex-msft here the error I get from the trubelshoting refresh window:

[v-shex-msft]

Hi @Noak,

It seems like a normal timeout error, maybe you can try to increase your timeout range in your connector.

Query Timeout on update

You can also find this option in advanced options of connector.

Regards,

Xiaoxin Sheng

[Noak]

@v-shex-msft while trying to refresh (it takes over 1 hour) and i see the following:

The refreshing process isnt finished yet.

any thoughts? ideas?...this datasource refreshing used to work in the past.

[v-shex-msft · Accepted solution]

Hi @Noak,

How many records in your datasource? Timeout issue also appears if there are too many records need to be refreshed.

BTW, power bi default timeout limit is two hours, you can also upgrade your license to premium to increase the refresh timeout limit.

Scheduled refresh timeout
Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you are encountering this limit, you can consider reducing the size or complexity of your dataset, or consider breaking the dataset into smaller pieces.

Regards,

Xiaoxin Sheng

[Noak]

@v-shex-msft yes but the time out error is after 4hours refreshing.