cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jbocachica Member
Member

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 works fine and the final size is about 175MB, however when I tried to refresh from the PBI website I'm receiving that error, I've another datasets using the same tables with diferent parameters and those are working fine.

 

Regards

John Bocachica
Senior BI Consultant
Information Workers
http://www.iwco.co
9 REPLIES 9
Super User
Super User

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

Probably best thing to do is generate the error and then send a "frown" in the Service with a screen shot of the error.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Moderator v-yuezhe-msft
Moderator

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

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

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

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

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

 

Regards

John Bocachica
Senior BI Consultant
Information Workers
http://www.iwco.co
ibarrau Established Member
Established Member

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

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

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

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 Established Member
Established Member

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

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.

sajidmansoorali Regular Visitor
Regular Visitor

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

i have the same issue data model size is only 247 mb

Jmenas Member
Member

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

Hi all,

 

Any updates on it?

I just have the same error and my dataset is ~75mb.  I am using OData Feeds. 

pbi error.PNG

 

 

Best,
J.

Highlighted
kingsiv Visitor
Visitor

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

I have the same issue as well; for a 650MB data model with Oracle. It says "The XML for Analysis request timed out before it was completed. Timeout value: 7200 sec." Then it specified my fact table. In my data model, the fact table is filtered, so that entire data model, with other lookup/dimensional tables, is less than 1GB (650MB to be exact). My fact table in the Oracle database is about 1.3 GB. I am using Power BI Pro. Could any of these be the reason why? Will going Premium solve this? 

 

I have tried various scenarios, including: refreshing the data model in Power BI Desktop and republishing (as a new renamed data model). My data model has a calculated table that uses SUMMARIZE from the fact table; can this be it?