Invalid Query Locator ISSUE - Salesforce Dataset

[Anonymous]

Hello.

I've created a Power BI report pulling data from Salesforce objects. Performed a lot of data modeling, appended queries, merged queries etc etc...

The reports worked and refresh fine when in Power BI Desktop. When I published to the web, this error keeps popping up and the dataset does not refresh. Sometimes it does, sometimes it doesn t. I've already contact Power BI support directly and Salesforce support also, none of them were able to solve the problem. 

Here is the error message:

There was an error when processing the data in the dataset.

Please try again later or contact support. If you contact support, please provide these details.

Messageinvalid query locator Table: ROT Parceiro 3.
Cluster URIWABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
Activity ID5c929b5d-0e4d-41b5-9e6a-8d53a28e2b08
Request ID758ea88d-e61c-df6a-dc28-0525e4c7aa4b
Time2020-02-21 13:50:29Z

This is the error message when I try to update the dataset report into Power BI Service.

Does anyone has any ideia how to solve this? I saw some posts regarding the same issue, but none of them could help me.

[QueryWhiz]

Hi, were you able to find a solution? I've used the Salesforce connector but I had some issues sometimes. 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. 

[v-diye-msft · Accepted solution]

Hi @Anonymous 

You might refer to this article:

https://help.salesforce.com/articleView?id=000323582&type=1&mode=1 

[Anonymous]

Hello. Thanks for your support.

Do you know what a query locator cursos This article attest that salesforce user must have up to 10 query locator cursor, but I can t quite understand how can I manage that limit in Power BI Desktop.

Thanks.