Forum Discussion

Evogelpohl's avatar
Evogelpohl
Helper V
9 years ago
Solved

Need a Sleep or Wait step in my Query - hitting API rate limits

I have a working Power query function to pass ~12,000 tweets to MS cognitive sentiment API.  Working just fine.   I'm paying for the S1 (100,000 calls / 30 days) pricing teir.  Even in testing my s...
  • DataChant's avatar
    DataChant
    9 years ago

    BTW - You may want to re-evaluate your approach. From the initial code above, you post a single message per API call. Instead you can send 1000 messages in a single API call, and repeat it on your entire dataset. You can learn how to do it in my blog here.