Power BI and Okta logs

[Anonymous]

Good afternoon everyone,

I'm very new to Power BI and it seems like a great tool, but I'm having issues trying to use Okta's API to connect and pull the logs.

Currently I do this manually (I log in, download the logs and load them into Power BI).

From Okta's site (https://developer.okta.com/docs/api/getting_started/design_principles.html)

Authentication

The Okta API currently requires the custom HTTP authentication scheme SSWS for authentication. All requests must have a valid API key specified in the HTTP Authorization header with the SSWSscheme. 

Authorization: SSWS 00QCjAl4MlV-WPXM…0HmjFx-vbGua

I've tried entering this as a web :

and

but I'm getting the "A web API key can only be specified when a web API key name is provided)

I tried this in Postman and it seems to be working ok.

I've read through https://msdn.microsoft.com/en-us/library/mt260892.aspx and I'm still a bit confused about how to fix the connection.

Any thoughts?

[Syndicate_Admin]

I am able to access the Okta logs but returns a list of 100 "RECORD" data items.  Each are nested log entry's.  How did you flatten the data?

[Anonymous · Accepted solution]

@Anonymous,

Add a new blank query in Power BI Desktop, then paste the following code in Advanced Editor and check if you get any errors.

let
    Source = Json.Document(Web.Contents("URL", [Headers=[Authorization="SSWS <your api token>", ContentType="application/json"]]))
in
    Source

And you can get API token according to this article:https://developer.okta.com/docs/api/getting_started/getting_a_token.html.

Regards,
Lydia

[Anonymous]

This solution did get me up and running. 

I am now able to make a connect and see some data.

For anyone looking to make a connected, the new blank query and advanced editor is what got me up and running (not sure why the wizard doesn't accept it)