Power BI connector Gift Soft Credits Table

Leah Heit

Hello, I set up the Power BI connector and when I went into the gift soft credits table and did some spot checking, nothing seemed to come out right. For example, the columns are gift id, gift softcredit id, softcredit constituent id, and amount. When I went into RE and searched by gift ID the corresponding constituent ID and amount were wrong. same with gift softcredit id. Has anyone else had this issue or know why this is happening? I'm not sure how to handle soft credits with this.

Alex Wong

@Leah Heit
you are confusing the different ID.

gift_id from API is gift system record id in database view

constituent_id is constituent system record id