Forum Discussion
How to set command timeout option
Hi abhi9255,
For SQL database, we can change the command timeout in Advanced options of Data source settings directly.
And here is the M code for your reference.
let Source = Sql.Databases("Servername", [CommandTimeout=#duration(0, 0, 35, 0)]), TestGatewayDocs = Source{[Name="databasename"]}[Data], dbo_Product3 = databasename{[Schema="dbo",Item="Product3"]}[Data] in dbo_Product3Regards,
Frank
I am using Dataverse and whenever I try to load (just two tables).
The data displays correctly in the Power Query Editor, but when I try to Close & Apply, it times out.
(My connection speed seems to be fine; 800+Mbps down, ~100Mbps up.)
Finding this discussion thread, I tried taking the CommandTimeout expression in the SQL solution:
,[CommandTimeout=#duration(0,0,35,0)]),
and adding it to my line, but it did not work:
I stayed with the same 35-minute setting (did not want to fiddle with days, hours or seconds at this point),
but I received an error that CommandTimeout is not valid.
Anything you can tell me would be helpful.
Thank you.