Microsoft Exchange - improve loading speed

[Marquian]

Hello,

I have been trying to load my email account dataset to PowerBi. After over an hour, it is still trying to load the data. I will admit this is a high-volume email account that is actively sending and receiving emails, while I am attempting to load the dataset. What can I do to increase the loading speed?

 

[lbendlin]

Cut down on the columns as much as possible.  What kills the performance are the lookup columns. Much like with the AD and SharePoint List connectors.

let
    Source = Exchange.Contents("user.name@domain.com"),
    Mail1 = Source{[Name="Mail"]}[Data],
    #"Removed Other Columns" = Table.SelectColumns(Mail1,{"Folder Path", "Subject", "Sender", "DateTimeSent", "DateTimeReceived", "Preview", "Id"}),
    #"Expanded Sender" = Table.ExpandRecordColumn(#"Removed Other Columns", "Sender", {"Name", "Address"}, {"Sender Name", "Sender Address"})
in
    #"Expanded Sender"

This code loads 35000 emails in about 5 minutes

[Marquian · Accepted solution]

Where do I load this? As a parameter?  @lbendlin 

[lbendlin]

This is Power Query code.  How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".

[Marquian]

The goal is to identify peak times and days when we recieve inbound emails, who are the senders, why are they emailing. We hope to modify personnel and schedules based on the analysis. 

[lbendlin]

What are you trying to achieve with the data once it is ingested?