Power BI Refresh Running into an infinite loop.

[rodri2196]

Hi People,

Its been 3 days that my power bi reports are running in an infinite loop and timing out after 5 hours.
These reports ideally take 1.5 hours to refresh but now they just time out.

This was one of the errors.
Data source error: The XML for Analysis request timed out before it was completed. Timeout value: 18000 sec. Table: Module Orders.
Cluster URI: WABI-AUSTRALIA-EAST-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 7bcdbfe4-a3bc-423e-8004-79d80e67b3bc
Request ID: 61d6aa18-770a-4e15-84dc-01ca84e81b6e
Time: 2024-08-02 00:53:43Z

Even my datamart stopped refreshing and times out after 5 hours.
Yesterday I got an error saying, DataSource.Error: Web.Contents failed to get contents from solver api

Why did it give me these errors?
Is it because of the microsoft Azure DDOS attacks that the services are slow? its been 3 days and I am struggling for solutions.

[Anonymous]

Hi @rodri2196 

Is your problem solved, and if so, please mark the corresponding reply as a solution, which will help users with the same problem to better solve their problem.

Best Regards,

Jayleny

[lbendlin]

Use SQL Server Profiler to identify which of your data sources causes the delay.

Visualise your Power BI Refresh - Phil Seamark on DAX

Visualize Power BI Refresh using Semantic-link - Phil Seamark on DAX