Forum Discussion
masplin
Impactful Individual
Impactful IndividualCant understand why this function based web query wont refresh
I have written 2 functions ot extract price data off the FT website. They seem to work fine in the query editior, but when i refresh they just time out. Fn are (Code as text) as table =>
l...
Maybe try to Table.Buffer( ) around the first or 2nd step.
AlexisOlson
Super User
Super UserI got better performance when I turned off Background Data.
You can try playing with parallel loading too.
Resources I found useful on this topic:
https://blog.crossjoin.co.uk/2019/10/13/why-does-power-bi-query-my-data-source-more-than-once/