The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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