Extracting Data from IDN to PowerBI

@mcheek I went ahead and submitted an idea for this: https://ideas.sailpoint.com/ideas/GOV-I-2386

I think there might be a workaround in the meantime.

  1. Import the identities that only have one account, since your solution works perfectly fine for those identities.
  2. Identify the identities that have more than one account. You can use this search query to find them: Get Users With More Than One Account in the Same Source - #7 by colin_mckibben
  3. Use the get account entitlements API to correctly map which entitlements belong to each account for the identity. You can probably just modify the access data you get from the identity search to include the account reference object that you want to see.