cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alex Regular Visitor
Regular Visitor

Optimizing getting data from Exchange

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"

 

2 REPLIES 2
Super User
Super User

Re: Optimizing getting data from Exchange

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?


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


alex Regular Visitor
Regular Visitor

Re: Optimizing getting data from Exchange

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