Having issues connecting PowerBI to Automox API

  • 16 November 2021
  • 7 replies
  • 1775 views

Badge

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?


7 replies

Userlevel 1
Badge

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

 

Userlevel 5
Badge +1

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?

 

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?

Userlevel 5
Badge +1

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

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

Userlevel 2
Badge

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

 

 

 

Userlevel 5
Badge +1

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

 

 

The value would need entered manually.

Reply