Forum Discussion
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 :-)
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
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
%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.
Regards,
Xiaoxin Sheng
Hi Anonymous,
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.
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 :-)
From where do you update the OnPremise Data Gateway?
