Assistance needed with integrating IT Glue and Power BI

[Anonymous]

Good afternoon everyone,

I'm very new to integrations between systems and Power BI. I would like to establish a connection between Power BI and It Glue. I've been provided with an API link that I can use for this purpose. When I press "Get Data" and then select "Web," at some point I'm prompted to fill in the web API. Here, I input the key I've been provided with, but then I encounter the following error message: "A web API key can only be specified when the web API key has a name."

Is there anyone who could assist me with the integration between IT Glue and Power BI by explaining this step by step?

Thank you in advance!

[tbdbitl08]

Hi there! I was wondering if you, or anyone else, had any luck in getting this resolved. I have some data in IT Glue that I would love to update via the API and not have to manually pull exports. I have the API Name, key, etc. but unsure how to get past this step to actually get it to authenticate and pull any data into PowerBI. 

[johnbasha33]

@Anonymous 

Sure, I can guide you through the process of connecting Power BI to IT Glue using its API. Here's a step-by-step guide:

1. Obtain API Key from IT Glue: First, make sure you have the API key provided by IT Glue. This key will be used to authenticate your requests to the IT Glue API. If you haven't obtained the API key yet, reach out to your IT Glue administrator to get it.

2. Open Power BI Desktop: Launch Power BI Desktop application on your computer.

3. Get Data: Click on the "Get Data" button in the Home tab of the Power BI Desktop ribbon.

4. Select Web as Data Source: In the "Get Data" window, select "Web" as the data source. This will allow you to connect to IT Glue's API.

5. Enter API URL: Enter the API URL provided by IT Glue in the "URL" field. This will be the base URL for IT Glue's API. For example, it might look something like https://api.itglue.com/v1/. Make sure to replace v1 with the appropriate version of IT Glue's API.

6. Enter API Key: After entering the API URL, you'll need to authenticate with the API by providing the API key. However, you also need to provide a name for the API key. This is the step where you're encountering the error message.

7. Provide Name for API Key: In the "HTTP Request Headers" section, you need to specify the API key along with its name. The format should be "X-api-key" = "YourAPIKey", where "YourAPIKey" is the API key provided by IT Glue. Additionally, you need to provide a name for the API key. You can use any name you like, such as "APIKey".

8. Click OK: Once you've entered the API key and its name, click on the OK button to proceed.

9. Connect and Transform Data: After successfully connecting to IT Glue's API, Power BI will load a preview of the data available from the API. You can then apply any transformations or filters as needed before loading the data into Power BI.

10. Load Data: Finally, click on the "Load" button to load the data into Power BI and start creating your reports.
    
    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Anonymous]

Hi @johnbasha33 ,

Thank you so much for willing to help me. I just have 2 more questions.

Do you know in step 5 where I can find the correct version of the IT glue API?

And my other question is how to execute step 7. Please see the image below. I've given Name and then a name, but I'm still getting the same error message that there is no name? How should I add this? For X-api-key, I currently have *valuekey* but when I executed it myself, I did change this to the correct key.

I hope you can help me further.

[johnbasha33]

@Anonymous 

pls check the below links

https://api.itglue.com/developer/

https://www.itglue.com/blog/automated-it-documentation/

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Anonymous]

Hello @johnbasha33 ,

Thank you for sharing the links, but unfortunately, I still can't make it work. I have now filled in the following:

I still get the error message "A web API key can only be specified when the web API key has a name. In the links you sent, I can't find how to add the name. Do you happen to know how to do that and where I should click to be able to add it?

Hopefully, you can help me further!