cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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? 


Udklip.PNG

Kind regards, 

Junior-BI-assi

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Refresh timeout

Hi @Junior-BI-assi ,

 

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.

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper II
Helper II

Re: Refresh timeout

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? 

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors