SailPoint to PowerBI for Continuous Auditing

[mcheek (Mark Cheek)]

Check my example here and see if that can get you started. You will have to change the search query to suit your use case

Extracting Data from IDN to PowerBI

@jodi_pruitt The trickiest part is that Power BI’s “Web” source does not allow oauth-type authentication, only basic and api key-based auth. In order to get around this, I had to create a “Blank Query” and do everything in Power Query. Here are some of the snippets… First, you need to get a token using your client credentials getToken = Json.Document( Web.Contents( param_root_uri, [ RelativePath="/oauth/token", Query=[ …