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. The service currently does not have a connector built in to Power BI.
Is this possible? If so, how would I go about doing it?
8 Replies
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.
Thank you for the guidance to connect, that was helpful. Any suggestions on how to pull more than 50 rows at a time?
Anonymous,
I too need this info. Have you made any progress?
Thanks!
- I am also trying to connect to IT Glue. Please do share how you figured it out.
