Optimizing getting data from Exchange

[alex]

Hello,

I've got a relatively simple query aggregating data from Office 365 Exchange accounts.....but it is slow.  Is there anything I can do to speed it up?  I've already tried turning off privacy.

Code below.

Much appreciated,

Alex

let
    emailaddress = "dummy@dummy.com",
    Source = Exchange.Contents( emailaddress),
    Mail1 = Source{[Name="Mail"]}[Data],
    #"Extracted Date" = Table.TransformColumns(Mail1,{{"DateTimeSent", DateTime.Date, type date}}),
    #"Expanded Sender" = Table.ExpandRecordColumn(#"Extracted Date", "Sender", {"Address"}, {"Sender.Address"}),
    #"Removed Other Columns" = Table.SelectColumns(#"Expanded Sender",{"Folder Path", "Sender.Address", "DateTimeSent"}),
    #"Grouped Rows" = Table.Group(#"Removed Other Columns", {"DateTimeSent", "Sender.Address", "Folder Path"}, {{"Count", each Table.RowCount(_), type number}})
 in
    #"Grouped Rows"

[Anonymous]

Do you need every record?  Could you filter out records by date, folder, or sender to cut down the amount of records before you need to expand?

[alex]

Hi,

I tried filtering for the last 3 months and then expanding the "sender" attribute but it's still really slow.  You're right, it's the expansion of the record.

Yes, I ideally I want it...but it's just to slow....

Thanks,

Alex