Refresh timeout

[Anonymous]

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 Danish). This often happens after about 1 hour, but a few times it works. 

I'm using Azure Table Storage databases and Azure SQL databases. The ones that are timing out are a Azure Table Storage databases. 

I have tried following this guide: https://stackoverflow.com/questions/51718344/how-to-set-a-max-run-time-timeout-for-power-query, but it did not work. 

And all other guides here seems to solve the problem for Power BI Service, but how do i fix this for Power BI Desktop? 

Kind regards, 

Junior-BI-assi

[v-xuding-msft]

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]

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?