Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
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?
Solved! Go to 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
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,
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
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)