Skip to main content

Power BI

New

Exchange Online connector filter on initial query

Vote (1) Share
Scott T's profile image

Scott T on 12 Dec 2022 16:21:11

Currently, the Exchange Online connector only has a single parameter,

optional mailboxAddress as nullable text

This gets the user's ENTIRE mailbox, from the beginning of time BEFORE the query has a chance to filter out the data. This refresh can easily take hours, when the goal of the query may be to only get data from the last 90 days.


The connector should be updated with other optional parameters such as:

Start Date & Time

End Date & Time

Tables to Retrieve e.g. {"Mail", "Calendar", "People", "Tasks", "Meeting Requests"}

other good filtering options to speed up the query.