Power BI connector Gift Soft Credits Table

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.