title: Excel Power Query - Sleep or Wait Command to Wait on API Rate Limit
body: <p>In Excel Power Query (PQ) 2016, is there such a function that can insert a "SLEEP 15 seconds" before proceeding?  Not a pause, but a sleep function. </p>
  
  <p>Problem:
  I wrote a function in PQ to query: <a href="https://westus.api.cognitive.microsoft.com/text/analytics/v2.0" rel="nofollow noreferrer">https://westus.api.cognitive.microsoft.com/text/analytics/v2.0</a>.  That function works fine, as designed.</p>
  
  <p>I have a worksheet with 10K tweets that I want to pass to that function. When I do, it gets to ~60 or so complete and I get an ERROR line in PQ.  A look at Fiddler says this:</p>
  
  <p><strong>message=Rate limit is exceeded. Try again in 11 seconds. statusCode=429</strong></p>
  
  <p>I think if I insert a SLEEP 5 second (equivalent) command into the PQ function, it won't do this.</p>
  
  <p>Help &amp; thanks.</p>