Forum Discussion

WorkHard's avatar
WorkHard
Icon for Helper V rankHelper V
6 years ago
Solved

Delay a web query before calling it

Hi, I'd like to delay a query from accessing the web content for 10 seconds.   Here's my current query:   let Source = Csv.Document(Web.Contents("httpsURL"),[Delimiter=",", Columns=5, Encodi...
Need Help
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    Hi WorkHard ,

    PowerQuery M is not my strong suit but I recalled a similar question. I think your M should work like this:

    let
    Source = Function.InvokeAfter( () => Csv.Document(Web.Contents("httpsURL"),[Delimiter=",", Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.None]),#duration(0,0,0,10)),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
    #"Promoted Headers"

     

    Kind regards

    Djerro123

    -------------------------------

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Keep those thumbs up coming! 🙂

JarroVGIT's avatar
JarroVGIT
Icon for Resident Rockstar rankResident Rockstar
6 years ago

Hi WorkHard ,

PowerQuery M is not my strong suit but I recalled a similar question. I think your M should work like this:

let
    Source = Function.InvokeAfter( () => Csv.Document(Web.Contents("httpsURL"),[Delimiter=",", Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.None]),#duration(0,0,0,10)),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
    #"Promoted Headers"

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂