Forum Discussion

Franklin1's avatar
Franklin1
Advocate I
8 years ago

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 refre...
Need Help
Franklin1's avatar
Franklin1
Advocate I
8 years ago

Anyone???

tmfitz's avatar
tmfitz
Frequent Visitor
8 years ago

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's avatar
    tmfitz
    Frequent Visitor
    8 years ago

    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. :smileysad:

    • ryanbird's avatar
      ryanbird
      Frequent Visitor
      8 years ago

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

    • GoTeam's avatar
      GoTeam
      New Member
      7 years ago

      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.