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...
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

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)