Forum Discussion
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 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
2 Replies
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.
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?
