Avatar
Carlos
  • Updated

Linking GpsGate REST API with Microsoft PowerBI

This article will guide you through the process to connect the powerful GpsGate REST API with Power BI. For those, who do not know what this means: Power BI is a business intelligence (BI) tool that helps you analyze data and create interactive dashboards and reports. It can connect to a wide variety of data sources, including Excel spreadsheets, cloud-based databases, and on-premises data warehouses.

Power BI is useful for a variety of purposes, including:

  • Data analysis: Power BI can help you explore your data and identify trends and patterns. You can use it to create pivot tables, charts, and graphs to visualize your data.
  • Dashboards: Power BI can help you create interactive dashboards that show a snapshot of your data. You can use dashboards to track progress, identify problems, and make decisions.
  • Reports: Power BI can help you create reports that summarize your data. You can use reports to share your findings with others or to track the performance of your business.

So, are you still using Excel to create reports and graphs?? don't be an oldie... press F5 in your system and learn how to go from Excel workbook to stunning report in Power BI Desktop

Requirements to do this connection:

Procedure: 

Open PowerBI in your system

Go to the option to get data in the upper left corner. From here you will select the option Other>Web and then click on Connect

A new window will pop up, and here you will select the advanced option. 

As an example for this guide, we are going to make a call of the status of our units (remember that in GpsGate the devices are users too, but with different privileges 😉), From the API documentation we will use the GET/applications/{applicationid:int}/usersstatus call. Also please change the URL from your server 

Please copy the Request URL and paste it into PowerBI in the URL section, changing the address with your data.

https://YOURSERVER.COM/comGpsGate/api/v.1/applications/APP_ID/usersstatus?FromIndex=0&PageSize=1000

Please in the HTTP Request header parameter write "Authorization" and proceed putting your "REST API Key or Token"

From now everything should work fine, the next window is the Power Query editor where you can change the format of the data and the properties of the column. 

And ta-da!! now you can visualize and play with the data as you prefer! Great job

 

 

 

Related articles