Forum Discussion

jbocachica's avatar
jbocachica
Icon for Resolver II rankResolver II
10 years ago

The XML for Analysis request timed out before it was completed.

Hi all, any idea about this error?   The XML for Analysis request timed out before it was completed. Timeout value: 7200 sec.   I'm using Azure Table Storage, if  I use PBI Desktop the dataset wo...
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi jbocachica,

Based on your description, you publish the PBIX file to Power BI Service and  fail to refresh the dataset, right? If so, the above error could be caused by that the data model size in your PBIX file is too large. As stated in this blog, refreshing the dataset will give an error message indicating you that your dataset is too large when data model size grows beyond 1 GB.

I would recommend you firstly rename the PBIX file to .zip and check the size of the data model file within. For more details, please review this blog. If the data model size is too large, please break up your dataset into smaller datasets and refresh them in Power BI Service.



Thanks,
Lydia Zhang

  • jbocachica's avatar
    jbocachica
    Icon for Resolver II rankResolver II
    10 years ago

    Hi Lydia, thanks for your answer, however the datamodel size is about 300MB.

     

    Regards

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper User
    9 years ago

    Hi yuezhe and jbocachica. Is there any updates about this? I have the same problema with a dataset of 300mb and is not bigger than a 1gb when changing to zip. This is my message:

     

    Error de procesamiento:The XML for Analysis request timed out before it was completed. Timeout value: 7200 sec.
    URI de clúster:WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
    Identificador de actividad:a5487894-6889-411d-bde8-560f10014b90
    Identificador de la solicitud:d965501e-4b38-4e5a-9db9-8e4888f7a712
    Hora:2016-12-02 03:04:18Z

     

    We tried to use smaller tables from the same data source, and it works correctly. The source is and SQL 2008 R2 on premise.

    Hope this can be solved. 

    Regards,

    • vakshi's avatar
      vakshi
      Frequent Visitor
      9 years ago

      I'm having the same error when refreshing data from oracle source:

       

      Processing error:

      The XML for Analysis request timed out before it was completed. Timeout value: 7200 sec.

      Cluster URI:

      WABI-WEST-EUROPE-redirect.analysis.windows.net

      Activity ID:

      19d86265-6ce6-a751-1a52-79da7e59e72f

      Request ID:

      a52b70b6-0191-51bc-cb53-99bd2b7fe2b0

      Time:

      2017-02-22 16:42:50Z

       

      Help (-:

       

      BR

      Itzik

      • ibarrau's avatar
        ibarrau
        Icon for Super User rankSuper User
        9 years ago

        I'm sorry to tell you that the way i solved it, is not a solution you are looking foward. I pay for more bandwith and reduce de size of power bi desktop file adding logic to a view in sql (instead of taking tables) and to dax, removing all posible from edit query. 

        The files start to size 500mb, and with more bandwith work in 5000 seconds.

         

        Regards,

         

        7200 is a power bi limitation.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I am getting a similar error 

       
       
      • pratafran's avatar
        pratafran
        Icon for Helper III rankHelper III
        6 years ago

        Any solution to this?

         

        I'm having the same issue. I have a PBI file of only 22MB that was working fine refreshing with an schedule on tha background and suddenly it stopped updating with the following error:

         

        The XML for Analysis request timed out before it was completed. Timeout value: 3600 sec

        If I refresh the BI from desktop it completes fine. So now I'm manually updating and re-uploading the file what is a very manual process.

        This is a PBI connected to Hana and some sharepoints (in import mode). 

  • AniketMS's avatar
    AniketMS
    Frequent Visitor
    2 years ago

    Hi -

     

    Can you please put some light on how to break up the dataset in smaller datasets and refresh?