AutomoxAutomox
API & Integrations

Having issues connecting PowerBI to Automox API

Dane
November 16, 2021 at 4:47 pm UTC

I am trying to get powerBi to pull data from:
https://console.automox.com/api/servers
I have been going over all the api documentation and reviewing powerbi support forums and I cannot get powerbi to pull the JSON
I get the following error: A web API key can only be specified when a web API key name is provided
image

I have tried using the API key as a username, doesn’t appear to work there either.
Has anyone gotten PowerBi to successfully pull data from the Automox web api, and how did you do it?

This discussion is archived and closed to replies. Continue it in the Automox Community Slack.

Discuss on Slack

Replies (7)

JLX89January 25, 2022
#1

I could be totally wrong, but isn’t the endpoint: 
https://console.automox.com/api/servers?o=[orgID]&page=0&limit=500 [o=OrgID]

 

jack.smithJanuary 26, 2022
#2

This process works

Once you build the initial query you need to add to accommodate for the # of assets in your organization. Using the page # as the different part of each query. Perhaps there is a better way?

 

bryan.singhMarch 30, 2022
#3

This process works

Once you build the initial query you need to add to accommodate for the # of assets in your organization. Using the page # as the different part of each query. Perhaps there is a better way?

 

Hi, is there a space between “Bearer” and the API key generated from Automox?

What is the purpose of putting Bearer?

jack.smithMarch 30, 2022
#4

Hi, is there a space between “Bearer” and the API key generated from Automox?

What is the purpose of putting Bearer?

 

A space was between “Bearer” and the API key generated from Automox. 

The purpose of adding Bearer is to tell the interpreter, in this case Power BI, to use the HTTP Authorization Scheme “Bearer” when authenticating. https://developer.automox.com/openapi/axconsole/overview/#section/Authentication

bryan.singhMarch 30, 2022
#5

Thank you for the quick reply. It does seem to work!

Afonso_Alves_31April 12, 2022
#6

I don’t see an authorization field on my powerbi configuration, am I looking the wrong place?

 

 

 

jack.smithApril 12, 2022
#7

I don’t see an authorization field on my powerbi configuration, am I looking the wrong place?

 

 

The value would need entered manually.

Back to all discussions