question

JakobKristiansen-6075 avatar image
0 Votes"
JakobKristiansen-6075 asked ArtemNaumchak-3815 answered

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?

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

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

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

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 Vote 1 ·

thanks.

1 Vote 1 ·

1 Answer

ArtemNaumchak-3815 avatar image
1 Vote"
ArtemNaumchak-3815 answered

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

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