Forum Discussion

rtrejo's avatar
rtrejo
Regular Visitor
4 years ago
Solved

Source{[Name="Mail"]}[Data] Query optimization

Hello, I have a query to connect via the exchange as I need to count the email addresses in a specific folder (Inbox) for 6 shared mailboxes.   I'm using a custom function:    let Source = (Acco...
Need Help
  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi rtrejo ,

    Before using the source table to transform data in Power Query directly, you can consider to select necessary rows in advance to reduce the table size to import into Power Query.

     

    In addition, if the source table would be used frenquently in a new query, you can try to Table.buffer() to buffer the source table. Please refer this blog which introduces it in details:

    Nested functions and Table.Buffer() 

     

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

     

v-yingjl's avatar
v-yingjl
Community Support
4 years ago

Hi rtrejo ,

Before using the source table to transform data in Power Query directly, you can consider to select necessary rows in advance to reduce the table size to import into Power Query.

 

In addition, if the source table would be used frenquently in a new query, you can try to Table.buffer() to buffer the source table. Please refer this blog which introduces it in details:

Nested functions and Table.Buffer() 

 

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