Enhance query performance of data loading via Microsoft Exchange Online

[BalazsNy]

Hi all,

I’m working on a report that is connected to a shared Outlook mailbox via Microsoft Exchange Online data connector. I only need this year's mailings, from a couple of senders, but there is no option to filter upon loading to Query Editor. As the mailbox contains thousands of mails the ETL process & scheduled refreshes are running VERY slowly. Do you have any tips to improve query & refresh performance? For example query folding or some kind of SQL statement upon loading?

[Anonymous · Accepted solution]

Hi @BalazsNy ,

Based on your description, here are some tips to help enhance query and refresh performance:
1. Utilize query folding
2. Configure incremental refresh

3. Using Native SQL Queries

For more details, you can refer to below document:

Query folding guidance in Power BI Desktop - Power BI | Microsoft Learn

Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.