Missing Salesforce Fields When Loading Data Into Power BI

[ltommylel]

Hey everyone,

I'm trying to load in data from Salesforce Opportunity History object into Power BI and a quite few fields are missing.  The important fields I'm looking for that isn's available is:
1. Stage Duration

2. To Stage

3. From Stage

Creating a opportunity history report in Salesforce and loading in the report is insufficient because of the 2000 row limit.  Am I missing a setting somewhere to have all the fields visible in Power BI?

@Salesforce 

[lbendlin · Accepted solution]

That's not how Salesforce History objects work.  You need to bring your own filter (in this case "Sales Stage"  for the "Field / Event" column, and then you can reconstruct the history from the "Old Value"  and "New Value" data.

Also note that the absence of a change record means the Sales Stage is the same as on the Opportunity object.  

[lbendlin · Accepted solution]

That's not how Salesforce History objects work.  You need to bring your own filter (in this case "Sales Stage"  for the "Field / Event" column, and then you can reconstruct the history from the "Old Value"  and "New Value" data.

Also note that the absence of a change record means the Sales Stage is the same as on the Opportunity object.  

[ltommylel]

@lbendlin Thank you for confirming that.  I found this reference doc that confirms those fields aren't available through SOQL.

[lbendlin · Accepted solution]

It's not that they are not available - the computation works very differently.  The complexity is more than compensated for by the much smaller storage size and the ability to recreate any moment in the history of each opportunity (for the captured field/event values)