Forum Discussion
Refactoring power query to reduce load time
Hi All, I have the following power query which I use to load data from an api call. This query works but the challenge is it takes too much time to load, I have 10K records (rows) which takes 30-...
1. If your API data source is slow to return the records then Table.Buffer is of no help
2. Can you limit the API response to only the fields you need?
3. You can shortcut the JSON traversal with the [key1][key2][key3][value] syntax, like a JSON parser does.
Is there a way to do profiling of query steps i.e. to find which step is taking more time to execute? As for api call, when I try the same api call via postman or curl, I get the result immediately. So my guess is some functions down the line are taking too much time to execute.