Best practice for Excel Dataset Refreshing

[jessical_7]

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.

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)

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 & Power BI desktop if the dataset is huge? Thanks in advance for your answering.

Kind Regards,

[some_bih]

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

[jessical_7]

Hi @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.