Data from MS Exchange

[Markzolotoy]

I need to get data from email server. First, which data source do I use?

This:

or this?

I tried both, they both work with the same problem.

I am getting emails only and when I expend Sender column and takes forever to apply. Any idea?

Thanks

[VahidDM]

Hi @Markzolotoy 

see these links:

https://community.powerbi.com/t5/Service/How-to-Connect-Microsoft-Exchange-Online-Datasets-with-Powe...

https://www.cdata.com/kb/tech/exchange-powerbi-gateway.rst

https://powerbi.microsoft.com/fr-be/blog/analyzing-your-microsoft-exchange-account-data-with-power-q...

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

Appreciate your Kudos!!

[Markzolotoy]

Thanks for the links, will go over them. But why after any transformation it takes a very long time to apply changes?

[V-lianl-msft]

The Query Editor just edit the queries. Power BI will perform it when you click “Apply”. If tables are too big, it will cost time.

You can refer to this blog to optimize the time  to apply changes:

https://blog.crossjoin.co.uk/2020/05/14/speed-up-data-refresh-performance-in-power-bi-desktop-using-...