Forum Discussion
Help please, Filtered File Folder import still evaluates contents of files filtered out
I have a folder that contains monthly files that go back years. For my purposes I only require the last 12 months. I filter the created date. This works fine, and the resultant import is limited to ...
I_Like_Pi
Power BI can only load the entire data then filter them out after. This is caused by huge amount of data to be processed, how many files and rows in your folder?
Take a look at my blog, try List.MaxN function.
Dynamically Display the Most Recent N Days using P... - Microsoft Power BI Community
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.