reporting shared mail - exchange server. powerquery very slow

Jakob Kristiansen 6 Reputation points
2021-03-01T13:04:23.06+00:00

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

73017-image.png

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,952 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Artem Naumchak 6 Reputation points
    2021-03-25T07:09:18.207+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments