cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
the_exception Occasional Visitor
Occasional Visitor

Power Query Slow When Pulling Data From Exchange

I'm attempting to pull in Categories and Attributes.LastModifiedTime in via Power Query, but it's going exceedingly slow, taking about an hour and a half to grab the approximately 50,000 e-mails in our Shared Mailbox.

 

I'm still relatively new to Power Query, so I don't exactly have a baseline.  The below is the code utilized to pull data in, is there something I'm missing?

 

let
    Source = Exchange.Contents("teammailboxname@company.com"),
    Mail1 = Source{[Name="Mail"]}[Data],
    #"Removed Columns" = Table.RemoveColumns(Mail1,{"Subject", "Sender", "DisplayTo", "DisplayCc", "ToRecipients", "CcRecipients", "BccRecipients", "DateTimeSent", "Importance", "IsRead", "Attachments", "Preview", "Id", "Body"}),
    #"Extracted Values" = Table.TransformColumns(#"Removed Columns", {"Categories", each Text.Combine(List.Transform(_, Text.From), ";"), type text}),
    #"Expanded Attributes" = Table.ExpandRecordColumn(#"Extracted Values", "Attributes", {"LastModifiedTime"}, {"Attributes.LastModifiedTime"})
in
    #"Expanded Attributes"
1 REPLY 1
Community Support Team
Community Support Team

Re: Power Query Slow When Pulling Data From Exchange

Hi @the_exception 

Do you use Power BI lastest version: September 2019 Update (2.73.5586.561)?

Or do you use power query for excel : version 2.59.5135.201 ? 

 

You could use Table.Buffer to speed up query.

There are many methods to speed up queries.

Speeding up power query

Performance tip for List.Generate (1): Buffer your tables in Power BI and Power Query

Table.Buffer for cashing intermediate query results or how workaround Unnecessary Queries Issue

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors