Power BI and API for Opportunity Days in Status?

Question

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!

Carol Grant · Answer

@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.

Ellen Smith · Answer

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

Dan Snyder · Answer

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