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