Power BI Integration Not Returning All Data from Blackbaud SKY API

Tejaswini Manohar

Hi everyone,

I'm working on a Power BI integration with the Blackbaud SKY API, and I'm noticing that the data being returned is incomplete across multiple tables.

This isn't limited to gifts—I've mapped several tables, and in each case some records that exist in Blackbaud are missing from the data loaded into Power BI.

I contacted Blackbaud Support, and they confirmed that the SKY API should return all available data and that there are no known API limitations causing records to be excluded. They suggested the issue may be related to my integration script or API setup.

Has anyone experienced a similar issue?

I'm looking for guidance on things such as:

• Common scripting or API configuration issues that can result in incomplete data.
• Whether there are filters, pagination, date ranges, or other request parameters I should verify.
• Best practices for validating that the API is returning all available records before loading them into Power BI.

Any suggestions, troubleshooting steps, or examples would be greatly appreciated.

Thank you!

Crystal Bruce

Hi @Tejaswini Manohar I'm tagging in my API super stars @Alex Wong @Erik Leaver and @Dan Snyder to see if they can provide any additional insight!

Erik Leaver

@Tejaswini Manohar - if you are using the Custom Connector, it does not include all available fields in the API. There are many threads on this topic in the community.

For accessing additional fields, you can fork the connector from the github repo and make updates or you can leverage Power Automate to get the additional fields you need.

Alex Wong

@Tejaswini Manohar as Erik has mentioned, if you are using custom connector:

• You should be getting all rows of data
  • all constituent records (NO non-constituent record)
  • all gift records
• You will not get all columns of data, there are still columns of data for constituent that is not expose by SKY API and the custom connector

When you say "incomplete", are you looking at data in Power Query of Power BI or in Power BI? Power Query is only a preview and does not load all data to start.