reporting shared mail - exchange server. powerquery very slow

Question

question

JakobKristiansen-6075 asked Mar 1, '21 ArtemNaumchak-3815 answered Mar 25, '21

reporting shared mail - exchange server. powerquery very slow

Hey. I want to see if it is possible to do some simple reporting on the number of emails on common mailboxes - and I can do that. Unfortunately, the loading time for data is really slow on large mailboxes. It seems that all data is loaded into the model - and my filters only come "afterwards" Is there an index or other quick method to reduce the time for your query?

Perhaps Powerplatform could schedule a query?

[1]: /answers/storage/attachments/72988-image.png

power-query-not-supported

image.png (3.4 KiB)

image.png (27.3 KiB)

· 2

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZhengqiLou-MSFT · Mar 02, 2021 at 07:13 AM

Hi,

Thank you for asking a question on Q&A forum, but based on my knowledge about Exchange, I think this question is out of our support, and it is more related to PowerQuery. So I will remove the Exchange tags and add the Power-Query-M tag. Hope your question will get resolved soon.

Regards,
Lou

1 ·

JakobKristiansen-6075 ZhengqiLou-MSFT · Mar 02, 2021 at 07:20 AM

thanks.

1 ·

Answer 1 · 2021-03-25T07:09:18.207Z

ArtemNaumchak-3815 answered Mar 25, '21

Hi,
As I see from your screenshot, you are using Text.StartsWith filter on text fields.
This filter shouldn't work for Exchange. Only Text.Contains( ) will work for text fields.
Please consider using it instead of StartsWith to reduce the number of rows being computed.

Also, your screenshot is cropped, please provide full M-query text, to get more recommendations.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question