Power BI Custom connector installed. Now how do I get the NXT end points I want into my dashboard?

Hayley Faba
Hayley Faba
Fourth Anniversary
in SKY Developer General Discussions

Hi all, I have just installed the custom connector and am ready to start building my dashboard. My issue is I cant seem to find that data points I want. For example, campaign, fund category, etc. Am I missing something? When I try to pull the data points from private lists I have in NXT, the columns that are loaded aren't the ones I see in NXT at all. Am I doing something wrong? Many thanks in advance!

Tagged:

Comments

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

    The campaign_id and fund_id can be found under the gift_splits column. You'll have to extract it from there, and then bring in data from the Fundraising>Campaign and Fundraising>Fund endpoints in order to get the actual names of the funds and campaigns.

    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 fund and campaign names, look up videos on creating star schemas within Power BI.

Categories