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.
v-juanli-msft
6 years agoCommunity Support
Hi tkboisvert
I can't find more solutions.
May ImkeF take some time to analyze this problem?
Best Regards
Maggie
- ImkeF6 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
- ImkeF6 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.