Forum Discussion

Brijesh's avatar
Brijesh
Frequent Visitor
7 years ago

Salesforce Object Refresh

I'm new to power BI and have no clue why this has happened? I have three different dataserts all has data source as "salesforce objects". I've built reports using salesforce objects and were on an a...
Need Help
metrica's avatar
metrica
Icon for Post Prodigy rankPost Prodigy
1 month ago

Hi Brijesh ,

 

The error shown is INVALID_QUERY_LOCATOR for the Service Request table. This can happen when multiple Salesforce queries run concurrently under the same Salesforce account and a query locator is invalidated.

 

Since you have three datasets using Salesforce Objects, I would check whether their refresh schedules overlap. I would also:

  1. Test Service Request as a simple standalone query.

  2. Reduce the number of separate Salesforce queries where possible.

  3. Avoid running other Salesforce API jobs under the same account at the same time.

  4. Stage shared Salesforce data once if several datasets use the same objects.

If Desktop refresh completes but still returns no records after April, check the Power Query date filters and confirm that the same Salesforce user can see the newer records.

 

Another option is Power BI Connector for Salesforce by Metrica Software:
https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577

 

It provides an alternative to the native Salesforce Objects connector and lets you select objects and fields, apply filters, preview the output, and use SOQL when needed. It will not repair the native connector error directly, but it can provide a more controlled Salesforce-to-Power BI path.

 

Docs:
https://metricasoftware.com/docs/salesforce/

 

Cheers,
Metrica Team