Forum Discussion

jsquaredz's avatar
jsquaredz
Advocate I
10 years ago
Solved

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 m...
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    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.

     

RaulSanchez's avatar
RaulSanchez
Frequent Visitor
8 years ago

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's avatar
Dax_Rookie
Frequent Visitor
8 years ago

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

 

Problem:

 

Attempted solution:

 

New problem:

 

Trying to reduce argument number to 2:

 

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!