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
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