Zooming in on API calls per request from Monitoring

Go to English version

For an Invantive Power BI user, the new drill-down capability from requests to API calls provides direct insight into performance and API usage: for each request, you can see how much data and how many rows were retrieved, from how many administrations, how many API calls were needed and how long each step took. By zooming in to Session-IO level, it becomes clear where delays occur and whether data comes from cache. This makes optimising, managing costs and keeping reports stable considerably easier.

Zooming in

For some time now, Invantive Cloud has offered a timeline where, for a period such as a day, requests are listed one below the other with time shown horizontally. This makes it quick and easy to establish the number of requests and their duration:

The Timeline can be found via the Monitoring menu (red 1). Hovering over a request (red 2 and red 3) brings up a window.

Clicking on the request shows the details of the request:

For this request, it is visible that approximately 5 KB of data was retrieved, consisting of 150 rows from up to 10 Twinfield administrations. The number of API calls was limited to 2.

Via the Session-IOs button, you can now retrieve the corresponding API calls:

Note that there are three lines on the screen: one of the session I/Os was not an API call but rather the sending back of the 5 KB of data to, in this case, Power BI.

The columns describe precisely how long the API calls took, how much data was exchanged and whether the data is fresh or comes from a cache. Often the number of rows is also visible.

Please note! Only data from requests made on the current day (since 0:00 UTC) is visible. Session I/Os from previous days are not available.