Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 :

 

 

 

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?

 

 

 
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      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)

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    2 years ago

    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?