Forum Discussion
Salesforce Object (Dataflow Entity) fails refresh when Incremental Refresh is enabled
Hi, I have created a dataflow entity from a salesforce object containing several years of case data. The goal was to setup an incremental refresh for only new data, since the past data will never cha...
"I need to refresh this data every hour, so a 15 minute refresh is way to long. "
No it is not. If it would take 65 minutes then it would be too long. 15 minutes is wholly acceptable on the Power BI side. You may get an angry call from your SFDC admins for blowing through the API call allowance but that is a different story.
The Salesforce connector does not natively support incremental refresh. You need to be very careful to set that up and make it work satisfactorily. Please describe your setup, or show the Power Query code. Use the Power Query Diagnostic tool to verify that SOQL query folding is actually happening.