Gift Split is missing from Gift in PowerBI

Iris Tam

I am able to set up the Blackbaud connector in Power BI. But I don't find any gift_split_id or fund_id field in Gift table to link to the Fund table. I'd already turned on allowing no validation/warning option in “Data Extension” and I am an full access to RE NXT. Is there anything else I am missing?

Ben Regier

Hi @Iris Tam - if you're still working on this, the gift_split column (and several others) are Table columns, so in order to access the data within them, you'll need to go to Transform Data in Power BI.

Iris Tam

Thanks Ben. I found the “Expand” icon on the column header in Transform Data.