Forum Discussion

glennbuck523's avatar
glennbuck523
New Member
8 years ago

How to filter data during import of Salesforce table?

Is there a way to filter data during the data load from salesforce tables?  This is compared to filtering the data AFTER all of the data has been loaded.   We are trying to connect to salesforce ta...
glennbuck523's avatar
glennbuck523
New Member
8 years ago

Anonymous

 

I did start going down that route but then in all of the mentions it was noted there was a limit of 2k records so i stopped since i know my end result will be more than that.  I was playing around with connecting to the tables directly.  After i established filters in the powerquery itself it drastrically reduced the amount of records returned and time it took.  It seems like only the first time I connected, before i had a chance to add filters, was causing me to pull back the entire table.  I think my issue was connecting to the source the first time in the PowerBI visualization portion compared to in Query Editor was the culprit...

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    glennbuck523,

    By using the built-in salesforce connector in Power BI Desktop, I am afraid that you are only able to add filter in Query Editor after importing the whole table.

    Regards,
    Lydia