Query Recommendations to be Used for Power BI?

Brooke Johnson
Brooke Johnson
Third Anniversary Name Dropper Facilitator 1
in Blackbaud Altru® General Discussions

Is anyone willing to share the queries they use to create reports in Power BI? I'm specifically looking for membership queries but would also appreciate any that you're willing to share. Screenshots of your queries would be fantastic!

Also, is there a way to build a query that replicates the exact information returned in Altru's built-in reports? I'd like to recreate these reports in Power BI but am having a difficult time getting my queries to return the same results as the reports in Altru.

Tagged:

Comments

  • Holly Finneran
    Holly Finneran
    Sixth Anniversary Kudos 1 Name Dropper Participant

    Hi @Brooke Johnson,

    I have been using Power BI with Altru for the last year, it has been a learning experience. I have not been doing queries with Membership yet, mostly focusing on Admission Tickets and their revenue. I have found that sometimes you need to use multiple queries to achieve the results that are needed. If you want to message me, I would be happy to see what I can do to help.

Categories