Power Query - Data from Email Attachment

[@Paladin101]

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]

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

[@maciejkopczynski55]

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

[@bcti-bcti]

I agree; it is pretty cool.

[@noneyabeezwax8865]

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

[@bcti-bcti]

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

[@captvo]

Brilliant! Very useful feature! Appreciate if the readers could mention the various scenarios that they have used this feature for.

[@bcti-bcti]

Thank you for saying so. I agree; use cases would be nice to read.

[@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!)

[@FsoOmar]

Fantastic! You never cease to amaze!

[@bcti-bcti]

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

[@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!!!!

[@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.

[@cpro671]

Great video, this will spawn lots of use cases…

[@bcti-bcti]

Glad to hear the video will help!!! 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.

[@Kiran-Shetty]

Superb 🎉

[@bcti-bcti]

@@Kiran-Shetty Thank you! 😊

[@Luciano_mp]

Wow, brilliant! Thank you!

[@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.

[@olipeeeeee]

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

[@bcti-bcti]

So glad it was helpful. Thanks for watching.

[@tavanix]

Hi! Great solution. Wondering, will it work with Power BI Reporting Server?

[@bcti-bcti]

@@tavanix I’ve not tested it using Report Server, but I don’t see why it wouldn’t.

[@BerndLegue]

Great video, thank you so much. I do have one question. If I make a Power Query Excel sheet for other people to use, would it be possible to have the outlook username & password as a parameter set in my sheet so anyone can put their info in without having to change the Query?

[@bcti-bcti]

@@BerndLegue I’ve never thought of that. I’m guessing that would not work because the username and password are not kept in the M code, rather in the credential cache of the P.C. I’ll look into it, but I would wager that it’s a “no”. Cheers. (Great question)

[@BerndLegue]

@@bcti-bcti That would be great. I already use that concept with VBA in Excel but I am a bit new to the Power Query stuff.

[@Bondoz007]

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.

[@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.

[@charliep1581]

Have you checked the contents of your CSV files? The TranDate column contains two types of date format - DD/MM/YY and MM/DD/YYYY.

[@bcti-bcti]

I must be blind because I'm not seeing any formatting difference. Can you tell me which file(s) and an example of the difference? Thanks.

[@charliep1581]

Apologies, it my error! Keep up the good work 👍​@@bcti-bcti

[@bcti-bcti]

@@charliep1581 thanks. I appreciate you looking out for me. It helps me not look like a goober to others.

[@tinhoyhu]

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

[@bcti-bcti]

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.