cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Franklin1 Regular Visitor
Regular Visitor

invalid query locator - salesforce

Hey all,

 

I have a report created on PBI Desktop with data from Salesforce.

The report was created and published to power bi service months ago.

Everything worked perfectly - the report is refreshed as scheduled.

Everything is in the cloud, hence I don't need no Gateway.

Suddenly, in the last few weeks the schedule refresh is not working and the error message I receive is "invalid query locator Table:XXX".

The name of the table (XXX) is not defined, and each time it is a different table.

 

I have read in salesforce documents a lot about the query locator.

What i don't understaand is how it happens all of a sudden, and what is the workaround i can do in Power BI to overcome this issue.

 

Please assist.

 

Thanks a lot!

11 REPLIES 11
Franklin1 Regular Visitor
Regular Visitor

Re: invalid query locator - salesforce

No one?

v-yulgu-msft Super Contributor
Super Contributor

Re: invalid query locator - salesforce

Hi @Franklin1,

 

Please check whether table name "XXX" is an existing name in source dataset. Or whether it has been changed.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Franklin1 Regular Visitor
Regular Visitor

Re: invalid query locator - salesforce

Thanks Yuliana,

 

It is an existing name.

It is all worked well up until a few weeks ago.

 

Any other idea?

 

Thanks.

Franklin1 Regular Visitor
Regular Visitor

Re: invalid query locator - salesforce

Anyone???

tmfitz Frequent Visitor
Frequent Visitor

Re: invalid query locator - salesforce

I am having the same issue.  Cannot get my queries to Salesforce to refresh on schedule in PBI Service.  Works fine when I refresh from PBI Desktop.

 

Help!

tmfitz Frequent Visitor
Frequent Visitor

Re: invalid query locator - salesforce

Me too!  Been trying to work with PBI support for weeks now.  Have time schedule for today.  Will come back and update you. So frustrating. Smiley Sad

ryanbird Frequent Visitor
Frequent Visitor

Re: invalid query locator - salesforce

I have been having the same issue. Same error message as you. Also only using Salesforce sources, so not Gateway involved. Super frustrating.

GoTeam Occasional Visitor
Occasional Visitor

Re: invalid query locator - salesforce

Did you have any luck with support?  I'm having the same issue.  Even more strange is that the ever changing table that pops the invalid query locator refresh error doesn't have Salesforce as a source.  The table source is a reference to a base table.  Only the base tables queries Salesforce.  How can a table that doesn't query Salesforce cause a Salesforce error?   Something isn't adding up.  

 

Refreshing from desktop and republishing works in getting updated data to PBI Service.  However immediately after publishing I get a yellow triangle error in PBI Service beside my dataset that says my refresh failed despite the last refresh date being only moments prior.  

melrous Visitor
Visitor

Re: invalid query locator - salesforce

same issue! any idea?

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!

Top Ideas
Users Online
Currently online: 256 members 2,832 guests
Please welcome our newest community members: