Gateway connectivity issue

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.

Anonymous
8 years ago
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

6 Replies

Anonymous
Not applicable
8 years ago
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

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

Configuration logs

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

On-premises data gateway service logs

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.

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

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
  Helper IV
  8 years ago
  Hi Anonymous here the error I get from the trubelshoting refresh window:
  - Anonymous
    Not applicable
    8 years ago
    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