cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ivan_larson_cki Frequent Visitor
Frequent Visitor

Re: invalid query locator - salesforce

I've had this problem frequently, and it seems to be a matter of the file being strained in how much it can import. File size doesn't strongly correlate with the problem as I have files of 18 MB that refresh just fine and files of only 9 MB that can't refresh automatically. But once I'm importing from ~6 or more Salesforce objects into a dataset, I'll start getting "Invalid Query Locator" errors sometimes when refreshing. Sometimes, these errors arise infrequently enough that reports will still continue to refresh most times. But once I use 8 or more Salesforce objects in one dataset, there's almost no chance that the report will ever refresh in the PBI service. I have end users who need to see information stored across this many objects for various projects, and we need a solution for this problem.

epresson Frequent Visitor
Frequent Visitor

Re: invalid query locator - salesforce

Has anyone come up with a solution? I'm also having this issue. I have a report with 8 salesforce objects and it is not able to refresh via PBI service. 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 86 members 1,370 guests
Please welcome our newest community members: