Power BI Endpoints for NXT

Options
Reuben Schmitz
Reuben Schmitz
Fourth Anniversary Kudos 2 Name Dropper Participant
in SKY Developer General Discussions

I am looking for a Solicitor/Fundraiser endpoint to use with Power BI reporting. I have been unable to find one and am wondering if it is not present or if I am missing it. If it is not present, any ideas as to where to get this code to add this endpoint?

Tagged:

Comments

  • Ben Regier
    Ben Regier
    Sixth Anniversary Kudos 3 Name Dropper Participant

    This depends a bit on what you're looking for, as a fundraiser can be assigned to a constituent or a gift. (And maybe to a campaign or fund as well? I'm not sure about those.)

    If you're looking at Gifts, there is a column that will give you a list of all of the fundraiser's constituent ids that are associated with this gift. In order to use those in reports, you will have to extract them, and then bring in data from the Constituent endpoint in order to get their actual names.

    If you're new to Power BI, these might be things you haven't done before. There's a video on extracting values from a list here, and if you need help knowing how to bring in the actual names from the Constituent endpoint, look up videos on creating star schemas within Power BI.

Categories