Manual data refresh doesn't work / The XML for Analysis request timed out

[Jaenkins]

Hi,

For several days the manule refresh of our datasets does not work anymore in BI Service. We always get the same messages.

This happens even with small sets of about 140MB!

Is there probably a general problem on the Eurpoe North B Cluster?

Unfortunately this is a big problem because we can not publish any data corrections that are intercepted with the incremental load.

A few days ago, the share function did not work either.
Unfortunately, confidence in Power Bi is falling day by day.

VerarbeitungsfehlerThe XML for Analysis request timed out before it was completed. Timeout value: sec. An error occurred while attempting to save the dataset (reference ID '52e1cd77-306e-4b47-9864-5219d1304c58').

Cluster-URIWABI-EUROPE-NORTH-B-redirect.analysis.windows.net

Aktivitäts-ID778177fe-7468-43aa-a7dd-3c9f8caa20d0

Anforderungs-ID13c7f86d-1032-9361-98bd-1be08d6521d2

Zeit2018-07-06 09:34:24Z

[v-shex-msft]

Hi @Jaenkins,

Have you connector to oracle data source with premium license? If that is a case, there are other users submit similar issue at CRI 68430263.

Processing error: The XML for Analysis request timed out before it was completed. Timeout value: sec. An error occurred while attempting to save the dataset

Please share more detail information to help us clarify your scenario.

Troubleshooting the on-premises data gateway

Spoiler

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 logs link 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.

   

   

Regards,

Xiaoxin Sheng

[Jaenkins]

Hi @v-shex-msft,

Thank you for your message.
No, we have another data source (Hortonworks).
I think that the gateway works, because we have timed reports on the service which are updated daily (without failure).
Nevertheless, we will turn on logging and collect some data.

[Jaenkins · Accepted solution]

Problem solved.
After an update of the OnPremise Data Gateway (from May to June) everything is now running again.
It's just a pity that you have to find out for yourself and such basic functions as data updates no longer work.
Why are premium customers not informed that an update is absolutely necessary?

Dear Community,

keep the Gatway always up to date 🙂

[kushalt1996]

From where do you update the OnPremise Data Gateway?