Forum Discussion

abhi9255's avatar
abhi9255
Icon for Advocate II rankAdvocate II
8 years ago
Solved

How to set command timeout option

My query is taking more time to refresh and when i refresh im getting command timeout error . So i need to set command timeout option in Power BI desktop but it is disabled at the moment how to enab...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    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

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
8 years ago

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

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago


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?