reporting shared mail - exchange server. powerquery very slow

Question

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: /api/attachments/72988-image.png?platform=QnA

Answer 1

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.