Extracting Data from IDN to PowerBI

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

Hi everyone.
Looking for some assistance with integrating sailpoint with power BI. We are using Extracting Data from IDN to PowerBI as a reference guide however we are stuck at the point where we can’t extract the results from the query. Can anyone please provide us with some guidance regarding this.

2

Could you be more specific? Is there an error message? Zero results? It would help if you posted your power m query here

3

Hi Mark

Hope you are well.

I have tried your exact query from the same topic that has been closed, but I when I apply the query I get a response saying “1 row added”.

4 
let
    getToken = Json.Document(
        Web.Contents(
            param_root_uri, 
            [
                RelativePath="/oauth/token",
                Query=[
                    grant_type="client_credentials",
                    client_id=param_client_id,
                    client_secret=param_client_secret
                ],
                Content=Text.ToBinary("hi")
            ]
        )
    ),
    token = getToken[access_token],
    authToken = "bearer " & token,
    getIdentities = (Offset) =>
    let docs = Json.Document(
            Web.Contents(
                param_root_uri,
                [
                    RelativePath="/v3/search",
                    Headers=[
                        #"Authorization"=authToken,
                        #"Content-Type"="application/json"
                    ],
                    Query=[
                        limit = "250",
                        offset = Number.ToText(Offset)
                    ],    
                Content=Text.ToBinary("{ ""indices"": [ ""identities"" ], ""query"": { ""query"": ""(attributes.cloudLifecycleState:active OR attributes.cloudLifecycleState:legalHoldActive OR attributes.cloudLifecycleState:prehire OR attributes.cloudLifecycleState:rehire) AND identityProfile.name:\""Mulesoft Profile\"""" }, ""queryResultFilter"":{ ""includes"": [ ""id"",""displayName"", ""employeeNumber"", ""manager.displayName"", ""manager.name"", ""access.id"", ""access.type"", ""access.displayName"", ""access.description"", ""access.privileged"", ""access.source.name"",""access.source.id"",""access.value"" ] },""sort"": [ ""id"" ]}")
                ]
            )
        )
    in docs,
    results = List.Generate( 
        () => [Offset = 250, identities = getIdentities(0)],
            each not (List.IsEmpty([identities])),
            each [ identities = getIdentities( [Offset] ), 
                Offset = [Offset] + 250 ],
            each [identities]
    )
in
    results
5

We have applied the parameters correctly and the results continues to put the entire query in plain text in a table.

6

You’re using the values for my identity profile and lifecycle states, which more than likely differ at your org.

You need to sub those values from identityProfile.name and attributes.cloudLifecycleState to match what you have in your org. Try that and see if you get different results

7

You can checkout our secure data share. It is a paid feature, but it makes it very easy to synchronize your IDN data into an AWS Snowflake instance. You can then connect your PowerBI instance to your Snowflake instance for your reporting needs.

8

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