How to pull Budgets? FE

Options
Justin Mitchell
Justin Mitchell
Name Dropper First Anniversary Facilitator 1
in SKY Developer General Discussions

Does anyone know how to pull budgets in using the connector or API similar to how it is in the FE system

Tagged:

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Justin Mitchell
    There is an API endpoints for pulling budget information
    https://developer.sky.blackbaud.com/api#api=56eb17a0a9db9516c46bff6f&operation=GetBudget

    so the question really is, what are you trying to get that these endpoint aren't providing?

  • Justin Mitchell
    Justin Mitchell
    Name Dropper First Anniversary Facilitator 1

    @Alex Wong
    Thank you for getting back to me
    how could I get these endpoints into this connector or into powerbi

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Justin Mitchell
    If the latest power bi connector doesn't have the endpoint data you want, then someone will have to make change to the connector, keep in mind that the PBI connector is not Blackbaud created/certified and maintenance by individuals). If you got the expertise, you can add to the connector yourselves, or you can wait for next update.

    You can also directly call the SKY API endpoint using Power Automate or any other programming language, and save the data in SharePoint/Onedrive or any other cloud storage that can be read into Power BI

  • Justin Mitchell
    Justin Mitchell
    Name Dropper First Anniversary Facilitator 1

    @Alex Wong
    I guess doing that might be what I need to do. do you happen to have a step-by-step on how you do it? it a video that works well

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Justin Mitchell
    Hi, I do not use the PBI connector, instead I have a data warehouse where I pull all information I need for reporting in RE and FE. then my PBI connects to the data warehouse (azure sql server) to get the data, including budget data.

    There is a few tutorial post on communty that you can search on how to do this, regardless of if you plan to do data warehouse or other storage solution.

Categories