Forum Discussion
Connecting Power BI to a Web Service
Hi all, I would like to connect Power BI to a web service that stores IT information and documentation (IT Glue), so that I can get data on how the service is being used within my organization. T...
The documentation for generating an API key for IT Glue can be found here:
https://kb.itglue.com/hc/en-us/articles/236404927-Getting-started-with-the-IT-Glue-API
The endpoints for the service can be found here:
https://api.itglue.com/developer/
To connect:
- In Power BI select Get Data > Other > Web
- Click Advanced. In URL parts enter https://api.itglue.com/<endpoint> where <endpoint> is the name of one of the items from the list. For example https://api.itglue.com/operating_systems
- For HTTP Request header parameters enter x-api-key in the left box and your generated API key value in the right box. Hit OK. Use Anonymous connection.
- Right click on the file in the query editor. Select JSON. Click List. Right Click List and convert to a table. Expand table as needed.