Setting Timeout Settings for Dremio Connector

[jajohnson]

Good day.

Is there a way to set the qeury timeout settings for Dremio Connector. I am seeing different posts online with regards to using CommandTimeout and Timeout options but this does not seem to work for Dremio Connector. 

What would I need to modify in the connection string below:-

= Dremio.Databases("server name", null, null, null)

I tried the following power query settings but this does not work. It instead throws me some errors indicating Expression.Error: We cannot convert a value of type Record to type Text

 = Dremio.Databases("server name", null, null, [CommandTimeout=#duration(0,0,30,0)]) 

[jjac_pbi_1979]

Hello, Liu. I tried the solution you're suggesting. I even did it before creating my own post, but keep getting same error message. Message refers to converting value true to type text, as you could see in the image below. 

I did several research on this, but haven't found any kind of solution for it. 

If there were any other option or advise you could provide, it would be great. 

Thanks! 

Error message when trying to increase timeout.

[v-yangliu-msft]

Hi  @jajohnson ,

You can try this:

Dremio.Databases("server name", null, true, [CommandTimeout=#duration(0,0,30,0)])

This is the related document, you can view this content:

https://community.powerbi.com/t5/Power-Query/Convert-a-value-of-type-Record-to-type-Text/m-p/1522384

https://stackoverflow.com/questions/63614882/power-query-expression-error-a-value-of-type-record-can...

https://community.powerbi.com/t5/Power-Query/600-Second-Timeout-Setting/m-p/2293763

https://community.powerbi.com/t5/Power-Query/Function-Odbc-DataSource-error-with-Timeout-settings/m-...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.