Forum Discussion
Salesforce - DataSource.Error: invalid query locator Details: List
Hi,
Has anyone encountered this error when trying to expand a column or previewing its cells.
DataSource.Error: invalid query locator
Details:
List
If so, what did you do to resolve this issue?
Thanks in advance.
7 Replies
Hi danextian,
If possible can you share your .pbix file?
Not really able to suggest anything with the screenshot.Thanks !!
Hi danextian 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 danextian
INVALID_QUERY_LOCATOR is a Salesforce pagination or cursor error. The thread does not confirm that it was caused by mixed List and Table values.
I would test both Salesforce queries separately, reduce the fields and rows before the merge, and use Query Diagnostics to identify which step triggers the failure.
Power BI Connector for Salesforce may also help reduce source complexity by letting you select and filter the required objects, fields, and relationships before import.
AppExchange and 30-day trial:
https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577Docs and support:
https://metricasoftware.com/docs/salesforce/
https://metricasoftware.com/docs/salesforce/contact-support/Cheers,
Metrica Team
