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 SQL Server Database as my source
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_Product3
Regards,
Frank
Hi abhi9255,
Does that make sense, If so, kindly mark my answer as a solution to close the case please.
Regards,
Frank
Hi, v-frfei-msft
I keep getting scheduled refresh fails due to
Before the data import for (Data Source Name) finished, its data source timed out.
Why is there no option like this for PBI desktop for other sources like excel?Hi, what if Tabular is the source?
Where you can change timeout for PowerBI?
asazure://westus.asazure.windows.net/ucmbusinessanalyticscube
My source is the above from analysis services. How do I change the timeout code there?
I have many queries in the power i report, and i have also set up command timeout, But still when i try to refresh it fails with MSSql timeout error for one particular table.
Also how do you decide how much Command timeout should be ?
This does not necessarily help! We are running queries against an MSSQL DB and no matter where these values are set, the flows can fail after around 15 minutes due to timeout issues. You may need to contact the DB or Gateway admin to adjust the settings on their side.
