How to only pull the mails of the last week with a connection to Exchange through Power Query

[AlexandreRIVARA]

I use Power Query to connect to Exchange and then filter to only show the emails with a specific tag that I then turn them into a table of around 5 lines max.

The issue is that to get 5 emails I need to pull around 4000 lines through the connection. It takes time and ressources for nothing. I don't need the emails I already treated, nor do I need emails so old that there is no meaning to treat them anymore. I can easyly filter the whole list but that's not what I am looking for here.

Is there a way to limit the scope of the connection to only the las week emails ?

Any idea is welcomed, thank you.

[edhans · Accepted solution]

You can create a filter on the date column, but I do not think querying against Exchange will fold the queries. In SQL Server for example, Power Query creates a query that includes the date filter, send the query to SQL Server, which runs the query, then returns the results.

With non-foldable sources, you can still set the filter, but it has to pull all data down locally to apply the filter. So your results are correct, but the query takes much longer to run. So in your case, it has to pull down 4,000 records to show you the 50 you care about.

[AlexandreRIVARA]

It is exactly what I feared but at least it is clear.

Thank you