topic Re: Connecting Power BI to a Web Service in Developer

Connecting Power BI to a Web Service

Anonymous — Mon, 10 Jun 2019 16:52:20 GMT

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?

Re: Connecting Power BI to a Web Service

jessicadaniels — Fri, 09 Aug 2019 23:20:27 GMT

@Anonymous,

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

Thanks!

Re: Connecting Power BI to a Web Service

Anonymous — Mon, 12 Aug 2019 16:36:30 GMT

Yes I was able to figure it out.

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

Re: Connecting Power BI to a Web Service

Restless101 — Wed, 14 Aug 2019 05:08:01 GMT

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

Re: Connecting Power BI to a Web Service

Anonymous — Wed, 14 Aug 2019 15:46:01 GMT

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.

Re: Connecting Power BI to a Web Service

mclarin — Fri, 30 Aug 2019 14:08:13 GMT

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

Re: Connecting Power BI to a Web Service

Anonymous — Fri, 22 May 2020 19:08:16 GMT

This worked for me as well. Thanks!

Re: Connecting Power BI to a Web Service

Anonymous — Fri, 22 May 2020 19:58:40 GMT

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

Re: Connecting Power BI to a Web Service

Anonymous — Wed, 27 May 2020 00:20:00 GMT

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