No video :(

Power Query - Data from Email Attachment

Подписаться 6 тыс.

Просмотров 2,6 тыс.

50% 1

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:
www.bcti.com//...
Video on Avoiding "Helper Queries" in Power Query:
• Power Query - Avoid "H...
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

Опубликовано:

18 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 33

@maciejkopczynski55 28 дней назад

I've never seen anything like this! Simply extraordinary!!

@bcti-bcti 28 дней назад

I agree; it is pretty cool.

@Paladin101 26 дней назад

It’s almost like you’re watching my machine to see what problem I’m trying to solve 😂. Thanks so much for this. Not only are your videos perfectly presented (for me), they are so on point.

@bcti-bcti 25 дней назад

Glad to be of service. I'll keep monitoring your computer for future video topics 😄

@charlieprocaccini2125 Месяц назад

Great video, this will spawn lots of use cases…

@bcti-bcti Месяц назад

Glad to hear the video will help!!! Thanks for watching.

@noneyabeezwax8865 Месяц назад

You were so right… I love this video. Thank you.

@bcti-bcti Месяц назад

@@noneyabeezwax8865 Glad you liked it. Thanks for watching.

@excel_along_the_way Месяц назад

Definitely going to try this and if it works apply this. Thank you for this.

@bcti-bcti Месяц назад

@@excel_along_the_way You are most welcome. Good luck, and let us know how it turns out.

@mcegirl4 Месяц назад

Amazing and brilliant (both the video and you)!

@bcti-bcti Месяц назад

@@mcegirl4 That is so sweet of you to say. I told my wife; she rolled her eyes.

@mcegirl4 Месяц назад

@@bcti-bcti 🤣 (I think that’s her job!)

@olipeeeeee 26 дней назад

🙀 as always amazing 🙏 for sharing your knowledge with us. Very very helpful.

@bcti-bcti 25 дней назад

So glad it was helpful. Thanks for watching.

@ExcelWithChris Месяц назад

thank you my friend. Hope everything ok on your side. It's a mad world out there in the USA now. Best wishes. .

@bcti-bcti Месяц назад

Yep; things are a bit crazy here. It will all work out in the end. Thanks for the support.

@DingusBatus Месяц назад

Wizardry for sure.😀 but I like it. 🤩😍 My work won’t let me use the skills I already have but I sure is fun watching a proper expert at work and I will continue to watch and learn just for the fun of it.🤩😍

@bcti-bcti Месяц назад

@@DingusBatus thanks for the support!!!!

@tinhoyhu Месяц назад

Please cover connecting to a Gmail or Google workspace account. That would be so useful. Thanks!

@bcti-bcti 28 дней назад

I did spend some time looking into that as another video, but all I found were some rather expensive 3rd-party options to do that; nothing built in to Power Query. Microsoft really need to approve some sort of "free", included connector for those platforms. Thanks for watching.

@chrism9037 Месяц назад

Outstanding !

@bcti-bcti Месяц назад

Thank you!!!!

@danielgoncalveslima9350 Месяц назад

Cool! It is crazy simple and great. Maybe vídeo for gmail after a 🤠

@bcti-bcti Месяц назад

@@danielgoncalveslima9350 I’ll see what I can do. Thanks for watching.

@Luciano_mp Месяц назад

Wow, brilliant! Thank you!

@1qtaz Месяц назад

OMG, just what I need. I have 2 files that come in twice a month that I need to report on. Although they have the same data, they are laid out differently. I should be able to separate them and process them separately. I've gone into Outlook for survey data, but hadn't thought of if for this application. Thanks for the direction for my real world problem.

@bcti-bcti Месяц назад

@@1qtaz I love it when people say that. It makes it all worth while. Thanks for watching.

@SndfOmar Месяц назад

Fantastic! You never cease to amaze!

@bcti-bcti 28 дней назад

Thanks. I'll try to keep up that trend.

@Bondoz007 2 часа назад

Just checking if I'm doing this in PBI, the refresh via PBI server is enough? Does Outlook need to be open for "things" to happen (file transfer rules etc)? Or everything is email server based so refreshes will work? Thanks

@bcti-bcti Час назад

@@Bondoz007 as long as you have your email in an Exchange or Office 365 environment, it should work just fine.