Reply
MojoGene
Post Patron
Post Patron
Partially syndicated - Outbound

Excel Power Query connector to Exchange email??

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,

1 ACCEPTED SOLUTION
edhans
Super User
Super User

Syndicated - Outbound

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.

 

2020-04-28 13_10_14-.png



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

2 REPLIES 2
edhans
Super User
Super User

Syndicated - Outbound

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.

 

2020-04-28 13_10_14-.png



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

Syndicated - Outbound

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

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)