Forum Discussion
tkboisvert
6 years agoHelper II
Odd Web.Contents behavior making multiple calls to API based on load time
To be clear syntactically and logically, we're not having an issue. The clarification we need is based around API calls that take a long time to serve from source. From what we can tell, when PowerQu...
- 5 years ago
There is another method described here: Chris Webb's BI Blog: Speed Up Data Refresh Performance In Power BI Desktop Using Table.View Chris Webb's BI Blog (crossjoin.co.uk)
that might be more reliable.
ImkeF
6 years agoCommunity Champion
Hi tkboisvert ,
don't know the reason for this either.
If no further answer is coming up here, I'd recommend to post your question in this forum instead: https://social.technet.microsoft.com/Forums/en-US/home?forum=powerquery
ImkeF
6 years agoCommunity Champion
Hi tkboisvert ,
actually, there is a thing that you can try: Buffer the Web.Contents like so:
Binary.Buffer(Web.Contents(...
- tkboisvert6 years agoHelper II
Will do! I'll report back.
- arnaud_l5 years agoRegular Visitor
Thanks Imke, it worked for me!
- mattio5 years agoFrequent Visitor
this worked for me for the same problem