Problems Querying Salesforce Objects

[Barksdale]

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-2013", "31-dec-2025" ),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),
"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"MonthNameShort", FORMAT ( [Date], "mmm" ),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
"DayOfWeekNumber", WEEKDAY ( [Date] ),
"DayOfWeek", FORMAT ( [Date], "dddd" ),
"DayOfWeekShort", FORMAT ( [Date], "dddd" ),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" ),
"Date Days From Now", NOW()-[Date])

The problem i'm having is that when i try to connect to the "Lead" salesforce object i'm unable to perform any date based queries and it never reports an error. I'm doing the same thing i would have normally done which is form a relationship between the Date and the CreatedDate but it never seems to work. When i connect to the Salesforce Report: # of Leads and do the exact same thing it does work and all the queries start showing correct results. 

Here is the query for Lead:

let
Source = Salesforce.Data(),
Lead1 = Source{[Name="Lead"]}[Data],
#"Removed Other Columns" = Table.SelectColumns(Lead1,{"Email", "CreatedDate"}),
#"Reordered Columns" = Table.ReorderColumns(#"Removed Other Columns",{"CreatedDate", "Email"})
in
#"Reordered Columns"

Here is the query for the Saesforce Report

let
Source = Salesforce.Reports(),
#"00O610000014MWSEA2" = Source{[Name="00O610000014MWSEA2"]}[Data]
in
#"00O610000014MWSEA2"

Whenever i try to transform the CreatedDate in the Lead Object (trying to turn the DateTime to just a Date) i get 

DataSource.Error: Non-grouped query that uses overall aggregate functions cannot also use LIMIT
Details:
List

Again i'm not an expert at this but there seems to be something weird happening when i try to form a relationship between the date.

I could also be doing things completly wrong so if that's the case please let me know.

All the best,

[cacevedo]

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.

[ReportGuru]

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. 

[BKnecht]

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]

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/113... 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

[fcivardi]

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