Power Query - Data from Email Attachment

Learn how to use Power Query's Exchange Connector to connect to your email and read data directly from an email attachment without having to save or open the email attachment.

File Download Link:
https://www.bcti.com//wp-content/YT_Downloads/BCTI_PQ_From_Email.zip

Video on Avoiding "Helper Queries" in Power Query:
https://youtu.be/2TeLzgkv1H0

00:03 Overview of Process
00:57 Scenario 1 - Overview
01:24 Scenario 2 - Overview
01:40 Power Query M Code Download
03:03 Creating an Outlook Folder to Hold New Emails with Specific Attachments
03:55 Connecting to an Email Folder
06:07 Extracting Data from Email Attachment
07:45 Test to Bring in New Data
09:04 Create Query to Append New Data to Report
10:46 Testing the Append Email Data Query