Refreshing data in Power BI when you use Blackbaud (Beta)

Marsha Wynn
Marsha Wynn
Tenth Anniversary Name Dropper Participant Facilitator 1
in SKY Developer General Discussions

I have created 4 pages in a Power BI report. I'm unsure how to refresh it with the new gifts that come in. I have been going in manually and refreshing the data (which takes sometimes 15 minutes) and then re-publishing for my directors to use. Can it not refresh on its own somehow?

Comments

  • Ben Regier
    Ben Regier
    Sixth Anniversary Kudos 5 Name Dropper Participant

    I believe it is possible, but it's a bit of a process to get it set up, and you'll have to install a gateway on your computer and have it turned on and online during the refresh. I've looked into it in the past, but I don't currently have any reports that are worth going through all the steps to set this up.

    This post looks like it covers things pretty well.

  • Marsha Wynn
    Marsha Wynn
    Tenth Anniversary Name Dropper Participant Facilitator 1

    I have installed the gateway for Blackbaud (beta) but it won't update unless I select the GIFTS table and refresh. Then I have to re-publish because it won't refresh in the online version. I'm going to try to use the gifts from queries instead of straight from ALL the gifts to see if that works.

  • Matt Thacker
    Matt Thacker
    Fourth Anniversary Kudos 3 Name Dropper Participant

    Hi @Marsha Wynn, I believe what you're referring to is the NXT Power BI connector. That's just what allows Power BI to communicate with the Blackbaud API. To enable refreshing, you'll need to install a on-premise gateway (link). This allows the Power BI Service to connect to locally stored data source.

    Once you get the gateway set up, you should have an app in your Start menu that looks like this:

    a096f4a46fca499393fea1ac07ef2b9c-huge-im

    On the left hand panel, open the Connectors field and you'll be able to specify where your custom connectors are located. You should have your connector in:

    \\Documents\\Power BI Desktop\\Custom Connectors

    You should see Blackbaud come up as a connector.

    9a805021423363050409ee3902bd227a-huge-im

    You can then log into Power BI online and go to your dataset (make sure you're going to the dataset and not the report) and open the settings.

    f4248d249ef9b3b36ad16cbc02d9542b-huge-im

    From here you can map it to the appropriate gateway. Once that status turns green and says running, the scheduled refresh field will become available and you can set when and how often you want your report to refresh.

    Let me know if you run into any issues and I'd be happy to walk you through the who process.

  • Cathy Kollar
    Cathy Kollar
    Third Anniversary Name Dropper Participant Facilitator 1

    Hi Matt, Thanks for sharing this process! How would you modify these steps to connect & refresh to data stored in the cloud?

  • Matt Thacker
    Matt Thacker
    Fourth Anniversary Kudos 3 Name Dropper Participant

    What type of data source are you trying to pull from? Most cloud-based data sources will connect directly to Power BI Service and don't require the use of a gateway.

  • Marsha Wynn
    Marsha Wynn
    Tenth Anniversary Name Dropper Participant Facilitator 1

    @Matt Thacker, I am just pulling from the Blackbaud (beta). My IT department help me to get that setup, so I'm unsure if they installed the on-premise gateway. I have sent them the link. Thank you SO much. ?

  • Marsha Wynn
    Marsha Wynn
    Tenth Anniversary Name Dropper Participant Facilitator 1

    @Matt Thacker do you have to install a personal on-premise gateway on my laptop for that to work?

Categories