More details: The XML for Analysis request timed out before it was completed. Timeout value: 225 sec. Activity ID: eff809b2-03ac-4706-9813-3b96db326c2c Correlation ID: 2d661bae-a418-9231-d2b1-a2fb9cd0c806 Request ID: 474226a5-7911-456b-a636-889fb02a3cc6 T

Badugu,Jagadeeswari 0 Reputation points
2023-11-29T06:45:15.4533333+00:00

Hi,

Please explain why i am getting the below error resource error

when i used a slicer member ID which has 1M records is there any solution for this?

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

Activity ID: eff809b2-03ac-4706-9813-3b96db326c2c

Correlation ID: 2d661bae-a418-9231-d2b1-a2fb9cd0c806

Request ID: 474226a5-7911-456b-a636-889fb02a3cc6

Time: Wed Nov 29 2023 12:01:40 GMT+0530 (India Standard Time)

Service version: 13.0.22007.81

Client version: 2311.1.16680-train

Cluster URI: https://wabi-west-us-redirect.analysis.windows.net/

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,165 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,297 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. PercyTang-MSFT 12,501 Reputation points Microsoft Vendor
    2023-11-29T07:15:06.2866667+00:00

    Hi @Badugu,Jagadeeswari

    The data source is too large or complex to be imported within the timeout value. You can try to reduce the size or complexity of the data source, or increase the timeout value on the server or the client.

    Depending on your error, you can refer to these threads.

    https://community.fabric.microsoft.com/t5/Service/The-XML-for-Analysis-request-timed-out-before-it-was-completed/m-p/1958905

    https://stackoverflow.com/questions/55176136/datasource-error-analysisservices-the-xml-for-analysis-request-timed-out-before

    Best regards,

    Percy Tang

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.