Forum Discussion

Barksdale's avatar
Barksdale
New Member
10 years ago

Problems Querying Salesforce Objects

    Hello,   I'm new to Power BI but have a model that has a Calendar and use the Date field to create relationships between all my other models.   Calendar = ADDCOLUMNS ( CALENDAR ( "1-jan-2...
Need Help
cacevedo's avatar
cacevedo
New Member
10 years ago

The Salesforce connector seems to have been broken for some time now, since October.  The release of 10/16 seems to make things a bit worse.

  • BKnecht's avatar
    BKnecht
    Kudo Kingpin
    10 years ago

    I'm still experienceing this problem - my SFDC Contact table will not query - it "breaks" once 18,001 rows are loaded. Has anyone else been experienceing this? I have the most up-to-date version on PBI downloaded. Any suggestions on how to fix?

     

    • elsalvador182's avatar
      elsalvador182
      Advocate IV
      10 years ago

      HI I have the same problem....I got an email today from support telling me they are aware of the issue and are still working on a fix....here is an ongoing thread describing the same problem..http://community.powerbi.com/t5/Desktop/Extremely-Slow-Connection-to-Salesforce-since-update/m-p/11316#M2495 I just updated to the latest release today and still no fix....no error but will not load all rows from a Salesforce object...expecting 100K+ but only getting 32K

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Hi,

         

        I'm still having the same problem, even with the latest release (January 2016). Was anybody able to solve it, or to find a workaround?

        Francesco

  • ReportGuru's avatar
    ReportGuru
    Post Patron
    1 year ago

    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.