Power BI supports different API providers and for that reason, there are many ways to import and query data from an API.
The method described in this article has been tested with SwaggerUI and supports dynamic data. This means the integration will Query the API for real-time data, therefore, if data is added/modified on myITprocess new data can be obtained with a simple "Refresh" on Power BI, without the need for new data imports.
- Navigate to https://reporting.live.myitprocess.com/index.html to obtain the desired data source repository, take note of the folder as it will be used on the following steps (ex: /public-api/v1/clients returns a list of all clients - both active and inactive)
- Open Power BI and select Get Data.
- On the search bar, type Web > Select the Web option and click on Connect.
- Power BI will then request the details of the new data connection.
- Select Advanced
- Fill in the URL Parts according to the image below
- The HTTP Header Parameter is mandatory for this connection as it will contain the authentication.
- Manually add the Header MITP-API-KEY
- As a parameter insert your API Key on the next field.
Upon selecting OK you will be prompted with the data and you may start creating visuals that will, in turn, report the data in an efficient and user-friendly manner.
Here is an example of a fully interactive report built with Power BI visuals and the API Data.
As a courtesy, a template of this visualization will be available for download below. Make sure you replaced the shell data for your newly created Data Source Query.
Our API uses pagination to achieve maximum processing efficiency and timely response to queries. Currently, our pagination is set to deliver 100 results per page, retrieving the first page by default.
To work with the full set of data, and to make pagination happen seemingly in Power BI a few tricks, and formulas are needed on top of the regular data Query.
Power BI Query pagination has been covered on Youtube by Business Intelligence Professionals.
The link below contains a great tutorial made by the Youtuber "Curbal".
https://www.youtube.com/watch?v=05yhwnuCjRw
Please note that Power BI is a Microsoft Licensed Product, though the steps mentioned in this guide were tested and worked at the moment of publication, myITprocess cannot guarantee future compatibility of the API with third-party applications.
The community is encouraged to create and share solutions as they see fit with data generated by the API, however, at the moment of publication, the myITprocess support team does not offer support to any third-party applications.