Forum Discussion

Jaenkins's avatar
Jaenkins
Frequent Visitor
8 years ago
Solved

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.

 

 

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

 

Need Help
Show and Tell
  • Jaenkins's avatar
    Jaenkins
    8 years ago

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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

    • Jaenkins's avatar
      Jaenkins
      Frequent Visitor
      8 years ago

      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.

      • Jaenkins's avatar
        Jaenkins
        Frequent Visitor
        8 years ago

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