Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.