Forum Discussion
Helper IConnection Timeout Issue
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.
Super UserNeeds more details. Is this Direct Query or Import Mode?
- evebarratt
It's Import Mode.
- lbendlin
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.
mkj1213Helper II
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?
