Forum Discussion
Limit Table Expansion Power Query
Hello, My report is slowed down because I have to import a large dataset from Salesforce, and then filter on a small portion by latest date. My solution has been to find a way to filter on the d...
Hi Anonymous ,
What about removing the duplicate date rows?
May be ImkeF have the better ways to help you.
Best Regards,
Cherry
I'm not familiar with Salesforce-Source, so cannot advise how to filter at source. Recommend to search in this forum for it.
But instead of expanding, you can try to add a column where you retriev the MAX of the "EffectiveDate"-column:
List.Max( [<YourColumnName>][Effective_Date__c] )
And then filter / remove dups before expanding.
Impossible to predict performance in beforehand here.
Thanks for your response! That would require me to expand the column, which would still load every row.