Assigned fundraiser

Pippi Reader

Hello

i I have now linked sky API and Power BI and beginning to create reports but struggling to see how I can get data on all constituents who have an assigned fundraisers assigned to them with a specific type (relationship manager). I cannot figure out how to get this information. Am I missing something obvious?

Thanks

Pippi

Alex Wong

@Pippi Reader
Assuming you mean you are using the unofficially support Blackbaud connector for Power BI, yes you will not get the assigned fundraiser/solicitor information.

One way to do this is to use query API to get the data using Power Automate, and feed that data into your Power BI, I have a template here that you can try: https://community.blackbaud.com/forums/viewtopic/586/70826