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...
Do you need the report(s) specifically?
The Objects connection does not have the row limitation (though you'll need to "rebuild" the "report" in Power BI i.e. bring in related objects, join, merge, etc.)
Hello,
No, we can rebuild the report in PowerBI easy enough. We just have several hundred thousand rows in the given table but only want about 5,000 of them at any given time so using the Report option doesn't work due to the limit. But pulling back several hundred thousand records into PowerBI THEN filtering is a nightmare for performance.
Thanks,