Forum Discussion
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,
In Power BI Service, you are able to connect to salesforce content pack.
Regards,
Lydia
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...