Best practice for Excel Dataset Refreshing

Question

Hi All,I'm currently working on connecting Microsoft Exchange Data (Outlook email) to PowerBI. Although I'm aware of there's a connector built of Exchange data in Power BI, I didn't go with that option cause my dataset is huge and the refreshing speed is very slow by using the connector.&nbsp;Now I pull the data from Excel Power Query, the query looks like an api call and works the same way as the Exchange connector in Power BI, but the refreshing performance has been boosted (still a bit slow if merging queries)&nbsp;I'd appreciate knowing if you have any ideas regarding the best practice of Excel dataset refreshing, cause I need to keep the excel file open to refresh the query (refreshing has been set up in excel doc). Or in your opinion, maybe is there a better way to work with Exchange data &amp; Power BI desktop if the dataset is huge? Thanks in advance for your answering.&nbsp;Kind Regards,

some_bih · Answer

Hi&nbsp;jessical_7&nbsp; I use method from link&nbsp;https://learn.microsoft.com/en-us/power-query/connectors/microsoft-exchange&nbsp;I do not use it very often, monthly only 2-3 times and I am fine. Hope this help&nbsp;

jessical_7 · Answer

Hi&nbsp;some_bih, thanks for your thoughts. Can I know if it works well when you refresh the email data? Mine took around 15-30 mins if I click refresh.

Forum Discussion

Best practice for Excel Dataset Refreshing

2 Replies

Related content

Refresh dataset api

Refreshing dataset

Practice Dataset

dataset refresh

Best practice for Incremental Refresh