Forum Discussion
jbocachica
Resolver II
10 years agoThe 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...
kingsiv
8 years agoRegular Visitor
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?