Power BI
Needs VotesDataflow Power Query editor should honor command timeout value during preview & validation
Chris Meurer on 06 May 2021 02:01:10
Current behavior: When editing a dataflow, the power query editor will timeout after 10 minutes regardless of the CommandTimeout duration specified in the query command.
Example: Odbc.Query("MyServer", "SELECT MY_SLOW_RUNNING_QUERY", [CommandTimeout=Duration.From(0.02)])
After implementing my sweet idea: Power query validation would wait at least 30 minutes before timing out.
As it stands today, I lose literal-days trying to find the right moment where the stars align and the dataflow editor can refresh the preview successfully so that I can proceed to save my dataflow.
- Comments (2)
RE: Dataflow Power Query editor should honor command timeout value during preview & validation
Agreed, 100%, but I think such a control should be implemented in the options menu, and apply globally to Dataflows. The Dataflows editor's 10 minute limit makes it impossible to develop queries more complex than can be run in 10 minutes.In our use case, Databricks is the compute engine, and very frequently, fully folded queries take longer than 10 minutes to execute, but they are not fundamental/widely used enough to merit creating an entire table on Databricks.At present, it is impossible to develop these queries on Dataflows, as the Dataflows editor will refuse to even keep a connection alive longer than 10 minutes (even if it isn't doing anything but waiting for Databricks to respond).
RE: Dataflow Power Query editor should honor command timeout value during preview & validation
Hi Chris,Currently suffering with the same issue. How did you improve it to 30 min? Could you please share more details? Thanks in advance.