SailPoint to PowerBI for Continuous Auditing

[calebfare]

I am trying to figure out if there is a way to link SailPoint to PowerBI to serve as a continuous auditing tool. I was doing some research and found that this was discussed at a conference. I wanted to see if anyone had any information or a recording of this presentation that I could view. I am new to this so just looking for some ideas as to what a dashboard in PowerBI might look like and see what everyone else has been using.

Any comments or suggestions are appreciated.

[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=[ …