cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Blue714 Frequent Visitor
Frequent Visitor

Power BI and Okta logs

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 :

 

 

PowerBI1.jpg

 

and

 

PowerBI3.jpg

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

 

PowerBI2.jpg

 

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

 

PowerBI4.jpg

 

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?

 

 

 
1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Power BI and Okta logs

@Blue714,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

Re: Power BI and Okta logs

@Blue714,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Blue714 Frequent Visitor
Frequent Visitor

Re: Power BI and Okta logs

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)