Forum Discussion

masplin's avatar
masplin
Icon for Impactful Individual rankImpactful Individual
2 years ago
Solved

Cant 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...
Need Help
  • spinfuzer's avatar
    spinfuzer
    2 years ago

    Maybe try to Table.Buffer( ) around the first or 2nd step.

spinfuzer's avatar
spinfuzer
Icon for Solution Sage rankSolution Sage
2 years ago

Maybe try to Table.Buffer( ) around the first or 2nd step.

masplin's avatar
masplin
Icon for Impactful Individual rankImpactful Individual
2 years ago

so do you mean add it like this as last step in each functions?

 

let
    Source = Sql.Database("SomeSQLServer", "MyDb"),
    MyTable = Source{[Item="MyTable"]}[Data],
    BufferMyTable = Table.Buffer(dbo_MyTable)
in
    BufferMyTable

 

Thanks