Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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",
I'm using Dataflow. Is there any other configuration that I should review?
Thanks in advanced!
Solved! Go to Solution.
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.
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".
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.
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.
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