PowerBi - Actions

Options
Ryan York
Ryan York
Sixth Anniversary Kudos 1 Name Dropper Participant
in SKY Developer General Discussions

Hello,

I am interested in accessing Actions data through the PowerBI connector. Is there a way to use a NXT list instead of trying to load the entire Constituents Action table? I have been unsuccessful in loading that one because the amount of data.

Most interested in just the data for last week or month.

Thanks,

Ryan

Tagged:

Comments

  • Matt Thacker
    Matt Thacker
    Fourth Anniversary Kudos 3 Name Dropper Participant

    Hey @Ryan York, so the answer the technical answer about lists, is no (from what I can tell). Have you tried filtering it in Power Query and not loading the entire table into your model?

    If that doesn't work, there is a way to filter down the data that's returned in the connector so it's not pulling everything in. Depending on what you're trying to get, this may be an option.

    In the .pq file for the connector, there's a section where all of the tables are created via calls to the SKY API. You can update this line filter the API with any parameters that are available for that endpoint. Below is an example of what the line looks like before and after the update. In this example, only actions that have been completed are being returned.

    Before:

    {"Constituent action", ActionListType, "constituent/v1/actions"…}

    After:

    {"Constituent action", ActionListType, "constituent/v1/actions?computed_status=Completed"…}

    I've attached a document with screenshots of the .pq file and all of the available parameters for that endpoint (it's better for high res images).

    PowerBI Actions.pdf

Categories