Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have been using an API to pull data into Power Query and then PowerBI from a task management tool. The API documentation states that they limit requests to 100 request per minute per token. I have the following M that requests a list of the tasks; it only returns 100 records. Is there something in the way I wrote this that is making multiple requests? It only looks like one request to me, not one request per record. Is there a better way for me to do this?
let token = "XX_YV5JX1DMD5D3CDEVTGO58UT44YXXXXXX", endpoint = "2232929/task?include_closed=True", baseUrl = "https://api.clickup.com/api/v2/team/", url = Text.Combine({baseUrl,endpoint}), request = Web.Contents( url, [ Headers = [ Authorization = token ], Query = [ ] ] ), requestData = Json.Document(request), #"Converted to Table" = Record.ToTable(requestData), #"Expanded Value" = Table.ExpandListColumn(#"Converted to Table", "Value") in #"Expanded Value"
Judging from discussions on the vendors site, it does not seem that the API limit is really 100 records so I assume it's something I'm doing wrong. Thanks for any insight.
Solved! Go to Solution.
Hi @ChristyQV
It loads 100 rows by default.
Please read this thread to find some workarounds.
Hi @ChristyQV
It loads 100 rows by default.
Please read this thread to find some workarounds.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.