Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Refresh timeout

Hi all,    When i load new tables or refresh my current tables i get the following error message "Request did not succeed: The request was interrupted because of timeout" (See picture below in Dani...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi Anonymous ,

 

What did you do while transforming data in Query Editor? Please delete the steps firstly (with the condition that you add the CommandTimeout argument ) to check if it works fine . If it is caused by transforming, maybe you could implement it with DAX.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    The steps are as follows (Exanding data and changing the type of a single collumn) 

     

    let
    Kilde = AzureStorage.Tables("triggerevents"),
    alleventsY2020M1 = Kilde{[Name="alleventsY2020M6"]}[Data],
    #"Udvidet Content" = Table.ExpandRecordColumn(alleventsY2020M1, "Content", {"CustomerTriggerId", "Data", "EventDateUtc", "EventFound", "ResponseMessage", "Success", "TriggerName"}, {"Content.CustomerTriggerId", "Content.Data", "Content.EventDateUtc", "Content.EventFound", "Content.ResponseMessage", "Content.Success", "Content.TriggerName"}),
    #"Ændret type" = Table.TransformColumnTypes(#"Udvidet Content",{{"Content.EventDateUtc", type date}})
    in
    #"Ændret type"

     

    How do i add commandtimeout argument?