Anonymous's avatar
Anonymous
Not applicable
1 year ago
Status:
New

Pass Query Timeout Parameter in Denodo Connection String

It is currently possible to connect to a Denodo data source using a DSN or a connection string (Server=, DB=, Port=, SSLmode=) as described here - https://learn.microsoft.com/en-us/power-query/connectors/denodo. The connection string approach has a significant limitation in that you cannot extend the query timeout beyond the default 15 minutes. This problem does not exist using a DSN where it is possible to configure the query timeout within the DSN settings. I propose adding another parameter to the connection string for the Denodo connector to set a query timeout (Server=, DB=, Port=, SSLmode=, QueryTimeout=).

2 Comments

  • Being constrained to 15 minutes for queries within a reporting context is less than ideal. The addition of the QueryTimeout parameter would be incredibly helpful.

Recent ideas