Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.