Connection Timeout Issue

[evebarratt]

Hi,

I'm having an issue with a visual (table with many columns)  which says it exceeded the available resources after publishing it.

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

I noticed every time I try to open it, timeout value is always 225 sec so wondering if there is any way to increase this value. I already extended Command Timeout to 1 hour by adding below M code in queries.

Source = Sql.Databases("Servername", [CommandTimeout=#duration(0, 1, 0, 0)])

Or is there any other solutions except optimizing the report?

Thank you.

[AnthonySole]

On Desktop App go to Options/Report settings/Query Limit simulations. Change from Auto (Memory (1GB) Timeout Limit: 225 seconds) to custom.

[Anonymous]

Did you find any solution to your problem? Am facing the same issue and tried multiple options, still getting same timeout error.

[lbendlin]

Needs more details. Is this Direct Query or Import Mode?

[mkj1213]

Hello Ibendlin, i am having this problem with a Direct Query (Originally it was a live connection to semantic model built on Fabric lakehouse, then it fell down to direct query, when i tried to create a new column). When draging one of the DateTime columns to a slicer, i am getting the same exact error. i should admit that my datetime columns has billions of values as i am capturing ms in that column. Is there any thing i can do to overcome this error? 

[lbendlin]

 i should admit that my datetime columns has billions of values as i am capturing ms in that column. Is there any thing i can do to overcome this error? 

Direct Query has a hard 1 Million row limit.  

Split your datetime column into a date part and a time part.  Use only the date part for the slicer.

Drop the slicer and use the filter pane instead with Advanced Filtering.

[mkj1213]

Hello Again @lbendlin, the idea of the filter pane had helped alot when replacing the slicer. Now i am trying to to optimze the query time that is needed by power bi to query the delta table. Do you have any idea how power bi deals with partitions of the delta table, for example if i am setting my filter pane to one minute period in a certain day, and my partitioning is along a date column, would power bi knows that it should go look only on the partition folder of that day, without spanning multiple date folders? 

[lbendlin]

I think that is what is happening. Why don't you try it out and report back?

[evebarratt]

It's Import Mode.

[lbendlin · Accepted solution]

Note that there is a difference between connection timeout and command timeout. You can specify both.

In your case the reason may be different. Talk to the database administrator to see if they are enforcing a timeout on their side.