Connecting Power BI to a Web Service

[Anonymous]

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?

[Anonymous]

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. 

[Anonymous]

This worked for me as well. Thanks!

[mclarin]

Thank you for the guidance to connect, that was helpful. Any suggestions on how to pull more than 50 rows at a time?

[Anonymous]

That 50 row limit is a bummer, any solution for this?

[Anonymous]

Limit is on the API side for IT Glue. I was able to overcome the limit by adding "page[size]=1000" to my URL string as shown in this article, but they limit it to 1000 per query. Use the filters document to set filters on the query so you get the correct data that you need.
https://support.itglue.com/hc/en-us/articles/360004934057-Pagination-in-the-IT-Glue-API 

[jessicadaniels]

@Anonymous, 

I too need this info.  Have you made any progress?

Thanks!

[Anonymous]

Yes I was able to figure it out.

Is IT Glue the service you are trying to connect to?

[Restless101]

I am also trying to connect to IT Glue. Please do share how you figured it out.