Forum Discussion
Extremely Slow Connection to Salesforce since update
Advocate IVI have the exact same problem since Wed Nov the 25th, 2015. I have had everything set to auto refresh and have not changed anything in my report or salesforce setup for many days prior. I got the error during a schedule refresh Wed afternoon and cannot fix since.
Also, Refreshing from salesforce object in desktop is extremely slow.
I get the error "Column 'Id' in Table 'master data' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.
I have disabled all relationships i still get the error. I have started a new project pulled the same SF object table alone and i do not get the error. However, in report view filtering in visual level filters there is a nice big 'blank' checkbox which tells me there is a blank row in my table. I cannot find this blank row in query editor.
Also when importing other SF object tables, the tables are loading in query editor but they are not loading into report view. They load but the tables are completely empty except for headers.
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.
- elsalvador182
Still 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.