Forum Discussion
Extremely Slow Connection to Salesforce since update
Advocate IVStill following this thread.....is there an issue with get data from saleforce objects since last update?
Very long data pulls and it seems like its timing out and not pulling the entire table. I do not get a time out error.
Also, it will load data for some tables in query editor......but table will be empty once I close and apply and enter report mode. Very strange. No filters or relationships active, just raw data.
pulling a custom report ("Saleforce Report") works fine so its not a connection issue.
Advocate IVStill trying to get this to work no reponse yet from support.
Here is my update in my undying quest to resolve this issue.
On another computer, using a slightly older version of BI Desktop version 2.28.4190.122, creating a new project and connecting to the saleforce object works perfectly and loads all 158K rows.
Updating to the newest version 2.29.4217.341 on this computer and trying the exact same steps as above replicates the error I am getting on the initial computer. Loading the saleforce object stalls at exactly 12800 rows, "1 row error" can be seen in the loading dialog before loading ceases. There is no error message and only 12800 rows load.
Still down....help...losing ...faith
Still having this issue. I remember on an older version (2 versions ago?) the connection was flawless and there seems to be no movement on this from Microsoft.
QueryWhizPost Patron
Hi cacevedo 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.