Forum Discussion
Missing Salesforce Fields When Loading Data Into Power BI
- 2 years ago
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.
- 2 years ago
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)
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 Thank you for confirming that. I found this reference doc that confirms those fields aren't available through SOQL.