# SailPoint to PowerBI for Continuous Auditing

**URL:** <https://developer.sailpoint.com/discuss/t/sailpoint-to-powerbi-for-continuous-auditing/90704>\
**Category:** SHF Discussion and Questions\
**Tags:** identity-security-cloud\
**Created:** [November 25, 2024, 2:48pm UTC](https://developer.sailpoint.com/discuss/t/sailpoint-to-powerbi-for-continuous-auditing/90704 "2024-11-25T14:48:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![calebfare](https://avatars.discourse-cdn.com/v4/letter/c/e0b2c6/32.png) [@calebfare](https://developer.sailpoint.com/discuss/u/calebfare)\
**Post date:** [November 25, 2024, 2:48pm UTC](https://developer.sailpoint.com/discuss/t/sailpoint-to-powerbi-for-continuous-auditing/90704/1 "2024-11-25T14:48:33Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![mcheek](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/mcheek/32/23705_2.png) [@mcheek](https://developer.sailpoint.com/discuss/u/mcheek)\
**Post date:** [November 25, 2024, 4:31pm UTC](https://developer.sailpoint.com/discuss/t/sailpoint-to-powerbi-for-continuous-auditing/90704/3 "2024-11-25T16:31:41Z")

</div>

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](https://developer.sailpoint.com/discuss/t/extracting-data-from-idn-to-powerbi/9348/4):
>
> @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=[ …

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [January 24, 2025, 4:31pm UTC](https://developer.sailpoint.com/discuss/t/sailpoint-to-powerbi-for-continuous-auditing/90704/4 "2025-01-24T16:31:58Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.