Power query - exchange server - possible to connect directly to one folder in mail

kerygma

New member
Joined
Jul 11, 2016
Messages
19
Reaction score
0
Points
0
Every time I refresh my query, power query downloads all of my emails which slows down the query quite a bit. Is it possible to shorten the steps so that it only looks in one folder?
 
(To clarify, is there a step when I'm defining the Source and selecting Mail currently like this:
Source = Exchange.Contents("email address"),
#"Filtered Rows" = Table.SelectRows(Source, each ([Name] = "Mail")),
Mail1 = #"Filtered Rows"{[Name="Mail"]}[Data],
#"Filtered Rows1" = Table.SelectRows(Mail1, each Text.Contains([Folder Path], "\Specific Folder\")),
Is there a way to say Mail1 = #"Filtered Rows"{[Name="Mail"]}[Data]["Folder Path Specific Folder"]?

Thank you in advance for your help.
 
So I noticed a big difference when I changed my filter from "Text.Contains" to "each [Folder Path] = \folder path\". I don't know if this specifically has to do with query folding, but what I was seeing in the status bar (it going through and displaying every folder name in my entire inbox) no longer happens when I have it written this way. Now it's much, much faster.
 
Back
Top