cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jsquaredz Regular Visitor
Regular Visitor

Query Timeout on update

I am pulling in an update from a web source, but this source can take 3 minutes + to return data.  Power BI times out before the server responds.  I would like to adjust this timeout timer.  Can we make this user adjustable setting?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ankitpatira Super Contributor
Super Contributor

Re: Query Timeout on update

@jsquaredz What you need to do is in power bi desktop go to query editor then right click your web data source and click Advanced Editor. This will give you access to M code behind it. You need to specify timeout interval in there manually. See below image and then should work hopefully.

 

Capture.PNG

View solution in original post

10 REPLIES 10
Highlighted
ankitpatira Super Contributor
Super Contributor

Re: Query Timeout on update

@jsquaredz What you need to do is in power bi desktop go to query editor then right click your web data source and click Advanced Editor. This will give you access to M code behind it. You need to specify timeout interval in there manually. See below image and then should work hopefully.

 

Capture.PNG

View solution in original post

jsquaredz Regular Visitor
Regular Visitor

Re: Query Timeout on update

Thanks for the workaround.

 

[timeout=#duration(0,0,30,0)]))

 

Can you share these parameters?

 

Would like to see this as a setting in the query builder.

 

ChrisWilliams Regular Visitor
Regular Visitor

Re: Query Timeout on update

>>[timeout=#duration(0,0,30,0)]))

 

This is a TimeSpan like parameter, with the values representing Days, Hours, Minutes, Seconds.

 

So, this setting represents a timeout of 30 minutes.

jsquaredz Regular Visitor
Regular Visitor

Re: Query Timeout on update

Can you advise if its valid to go over for a given unit?

 

For instance 0,0,0,90 instead of 0,0,1,30

ChrisWilliams Regular Visitor
Regular Visitor

Re: Query Timeout on update

This seems to be fine.  I didn't directly test with the Power BI client, but I tested with the TimeSpan class in C# (I'm a developer), and it didn't complain at all.

Jmenas Member
Member

Re: Query Timeout on update

Hi @ankitpatira,

 

do you know if this could also work for OData-Feed?

 

Best,

J. 

RaulSanchez Frequent Visitor
Frequent Visitor

Re: Query Timeout on update

Yes, it works.

you have to add a "null" in between

OData.Feed("http://some.url/service.svc/", null, [Timeout=#duration(0, 0, 5, 0)])

 

Dax_Rookie Frequent Visitor
Frequent Visitor

Re: Query Timeout on update

I'm having a similar problem (I think), but the solution described here doesn't seem to work.

 

Problem:

Problem.JPG

 

Attempted solution:

Solution.JPG

 

New problem:

Problem2.JPG

 

Trying to reduce argument number to 2:

Solution2.JPG

 

I have tested the ODBC connection in the Windows "ODBC Data Sources" app and it worked. Any ideas what I could be doing wrong / if there are any other workarounds?

 

Thanks!

 

Ghuiles Regular Visitor
Regular Visitor

Re: Query Timeout on update

hi guys!

 

I kinda have a similar issue.

I am using the logic from Harry Gates to retrieve data from Essbase via XMLA.

http://harrygates-essbase-blog.blogspot.de/2016/09/power-query-how-to-connect-to-essbase.html

 

The timeout in my script is in the properties section, set to <Timeout>90000000</Timeout>

Despite this i am still getting the timeout error.

In Excel, with SmartView, i am able to retrieve the value in an acceptable time.

 

How can i solve this? Is there in PBI another timeout section somewhere???

Cheers.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 207 members 2,040 guests
Please welcome our newest community members: