Forum Discussion
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 auto refresh schedule of once a day. 2 of my reports is refreshing fine without any issue but but one report doesn't refresh at all anymore even from the desktop. It is not showing me any new data after 26th April 2019. Also when I tried to refresh on desktop manualy it run the refresh cycle successfully but NO new data loaded! And surprisingly two of other datasets are refreshing well without any issue - even on PBI service. All three datasets are using almost similar salesforce objects but has different set of information based on requirements.
Microsoft support has been everything but helpful. Has anyone out there experienced the same thing? How did you fix it? I have project deadline to deliver this by end of this month. If I cannot fix this I won't be able to hand this over to the business for them to use.
I haven't changed anything at all in the report anywhere, it just no longer seems to want to deal with Salesforce. I built the report months ago and set up the refresh schedule and haven't touched it.
When it tries to refresh on PBI service it gives below error;
The last successful refresh was on 12th April 2019, see below refresh history for this dataset;
Looking forward to get some genius solution.
Thank you,
Brijesh
3 Replies
Hi Brijesh ,
Here is a similar thread which has a solution from GCL , you could have a try.
If your problem is very urgent, you could create a support ticket there to get the most fastest and targeted solution.(If you have Pro license.)
Best Regards,
Cherry
Hi, Brijesh were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:
After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:
There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.
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:
Test Service Request as a simple standalone query.
Reduce the number of separate Salesforce queries where possible.
Avoid running other Salesforce API jobs under the same account at the same time.
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-3bd56b5c0577It 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
