Forum Discussion
Microsoft Exchange - improve loading speed
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 s...
Where do I load this? As a parameter? lbendlin
lbendlin
Super User
Super UserCut 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