Solved: Re: Excel Power Query connector to Exchange email?...

MojoGene · ‎04-28-2020

Is there a connector in Excel to get data from an Exchange email client? I can get it in Power BI no trouble, but there seems to be no similar connector in Excel.

Thanks,

edhans · ‎04-28-2020

Yes, it is there. Use the "From Online Services" if your Exchange is part of Office 365 or otherwise hosted.

Not all versions of Excel have this. Excel as part of Office 365 home does not. See this article. You need either an Enterprise license (E3, E5), or Office 2019 Professional Standalone, or probably one of hte government or educational equivalents.

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

edhans · ‎04-28-2020

Yes, it is there. Use the "From Online Services" if your Exchange is part of Office 365 or otherwise hosted.

Not all versions of Excel have this. Excel as part of Office 365 home does not. See this article. You need either an Enterprise license (E3, E5), or Office 2019 Professional Standalone, or probably one of hte government or educational equivalents.

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

MojoGene · ‎04-30-2020

Thanks. My organization does not have the Enterprise version of Excel, so I'll have to use Power BI.

Excel Power Query connector to Exchange email??

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024