topic Teradata Timeout not working in Power Query

Teradata Timeout not working

Juca — Wed, 23 Dec 2020 14:19:57 GMT

As shown in the document, my query always aborts in 10 minutes, even when I use the command: "CommandTimeout" > 10min.

Exemple:

= Teradata.Database("host",
[HierarchicalNavigation=true,
Query="
SELECT

databasename,

tablename

from dbc.tables",

CommandTimeout=#duration(0, 0, 35, 0)]

error:

I'm using Dataflow. Is there any other configuration that I should review?
Thanks in advanced!

Re: Teradata Timeout not working

v-yingjl — Fri, 25 Dec 2020 07:53:27 GMT

Hi Juca ,

Seems that could not reproduce it in my envrionment. Have you tried the same query in power bi desktop and has it had the same issue?

Best Regards,
Community Support Team _ Yingjie Li

Re: Teradata Timeout not working

Juca — Mon, 28 Dec 2020 03:02:39 GMT

Hi @Yingjie, I've tested on Power bi Desktop and 'timeout' only worked for less than 10min, times greater than 10min don't work either.

Re: Teradata Timeout not working

Juca — Tue, 29 Dec 2020 12:06:45 GMT

My workaround work. I informed an invalid date in RangeStart and RangeEnd. So, finally I can save the Dataflow and refresh all history based on parameters of incremental refresh.

Re: Teradata Timeout not working

Juca — Tue, 29 Dec 2020 18:27:20 GMT

I've found a article about Authoring Limits explains the timout in 10minuts, in my case happens in "query preview":

"Authoring limits are the same across all products. During authoring, query evaluations return previews that may be subsets of the data. Data is not persisted.

Hourly Evaluation Count: 1000

Daily Evaluation Time: Currently unrestricted

Per Query Timeout: 10 minutes".