cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Noak Member
Member

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.

Capture.PNG

 

 

 

 

 

 

 

 

 

 

BR,
Noa.
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Gateway connectivity issue

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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

6 REPLIES 6
Community Support Team
Community Support Team

Re: Gateway connectivity issue

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.

On-prem-data-gateway-UI-logs

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.

On-prem-data-gateway-event-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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Noak Member
Member

Re: Gateway connectivity issue

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

Capture.PNG

BR,
Noa.
Community Support Team
Community Support Team

Re: Gateway connectivity issue

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.

10.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Noak Member
Member

Re: Gateway connectivity issue

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

BR,
Noa.
Noak Member
Member

Re: Gateway connectivity issue

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

 

 

 

 

Capture.PNG

 

 

The refreshing process isnt finished yet.

 

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

BR,
Noa.
Community Support Team
Community Support Team

Re: Gateway connectivity issue

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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors