Reply
MojoGene
Post Patron
Post Patron
Partially syndicated - Outbound

Excel Power Query connector to Exchange email??

‎04-28-2020 03:12 AM

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,

Labels:
Message 1 of 3
1,199 Views
0
1 ACCEPTED SOLUTION
edhans
Super User
Super User

‎04-28-2020 01:14 PM
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

Message 2 of 3
1,172 Views
2 REPLIES 2
edhans
Super User
Super User

‎04-28-2020 01:14 PM
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
Message 2 of 3
1,173 Views
MojoGene
Post Patron
Post Patron
In response to edhans

‎04-30-2020 10:02 AM
Syndicated - Outbound

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

Message 3 of 3
1,148 Views
0
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.

Stop
View All
Top Solution Authors (Last Month)
View All
Top Kudoed Authors (Last Month)
View All