Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Josh97Ellis
Helper III
Helper III

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 change. However, when I enable an incremental refresh on case closed date, the dataflow fails to refresh. I get this message in the details: Error: Data Source Error : DataSource.Error: invalid query locator {[...]}.. RootActivityId = f95ed3a6-f874-42f0-91c3-5c9ab88d412c.Param1 = DataSource.Error: invalid query locator {[...]} Request ID: 9be5b8a5-79f7-b1a3-a2ac-cb4abac2b7b8.

 

When I have this option disabled, the refresh works as expected; however, the refresh takes about 15 minutes to refresh. I need to refresh this data every hour, so a 15 minute refresh is way to long. 

 

 

3 REPLIES 3
lbendlin
Super User
Super User

Try using a lower API version like 44 or 28 - those have been used for the longest stretches.

StevenVF
Helper I
Helper I

I have the same issue, Everything has been working perfectly for about 2 weeks, then all of a sudden i get this error:

 

Error: Data Source Error : DataSource.Error: invalid query locator {[...]}.. RootActivityId = c2a89e7e-52c5-4bb4-9e4a-bfda936f0854.Param1 = DataSource.Error: invalid query locator {[...]} Request ID: 675d8106-ac23-306a-945e-c60a589cb6e7.

 

If i turn incremental refresh off it works fine.

I read that Microsoft has changed the default API last month, so i check out SF and we are on 51, i tried connecting using that and still the same error.

 

Basically it's taken what was refreshing in 8 ins to about 65 as i have to turn increamental refresh off to get it to work.

 

Was there a resolution to this one? Any help would be greatly appreciated.

lbendlin
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors