PDA

View Full Version : Power query - exchange server - possible to connect directly to one folder in mail



kerygma
2016-07-21, 11:42 PM
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?

kerygma
2016-07-22, 06:35 PM
(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.

kerygma
2016-07-25, 03:36 PM
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.