Power BI and API for Opportunity Days in Status?

Ellen Smith
Ellen Smith
Second Anniversary Kudos 1 Name Dropper Participant
in Blackbaud Raiser's Edge NXT® APIs

Hi All! I would like to get days in status for opportunities into my power BI report. Is there a way to do that with some kind of API call without using the custom connector? I can't see a way to get it in a query or export, think this is the only way to get to that field. If I can't get it directly into BI with a call, is there some middle place I can dump it?Thanks!

Tagged:

Answers

  • Dan Snyder
    Dan Snyder Community All-Star
    Tenth Anniversary Kudos 5 April 2026 Monthly Challenge March 2026 Challenge: Answered Questions

    @Ellen Smith Check out the Opportunity Status History (Get) endpoint. It does have days elapsed as part of the response.

  • Ellen Smith
    Ellen Smith
    Second Anniversary Kudos 1 Name Dropper Participant

    Hi Dan! I saw that! I just don't know how to get that into BI.

  • Carol Grant
    Carol Grant
    Eighth Anniversary Kudos 5 First Reply Name Dropper

    @Ellen Smith - do you have or use Power Automate? You could create a flow that pulls the Get and then save that as a CSV file that you can import into Power BI. I've done that but the data that you get from the Opportunity Status History can be duplicated depending on how many changes there are, you can limit what gets returned but it does take a while to run depending on what you are looking for. We currently don't use this piece in Power BI because of those limitations.

Categories