cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jaenkins Frequent Visitor
Frequent Visitor

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

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.

 

Data Refresh failure 3.JPG

 

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Jaenkins Frequent Visitor
Frequent Visitor

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

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 :-)

3 REPLIES 3
Community Support Team
Community Support Team

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

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.

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.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Jaenkins Frequent Visitor
Frequent Visitor

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

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 Frequent Visitor
Frequent Visitor

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

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 :-)