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?

Where do I load this? As a parameter? lbendlin

Microsoft Exchange - improve loading speed | Microsoft Fabric Community

lbendlin
Super User
3 years ago
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("[email protected]"), 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
- Anonymous
  Not applicable
  3 years ago
  Where do I load this? As a parameter? lbendlin
  - lbendlin
    Super User
    3 years ago
    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".
lbendlin
Super User
3 years ago
What are you trying to achieve with the data once it is ingested?
Anonymous
Not applicable
3 years ago
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.