MSPTDA 05: Power Query: Excel.CurrentWorkbook Function to Append All Excel Tables in Excel Workbook

Download Excel START Files:
people.highline.edu/mgirvin/A...
people.highline.edu/mgirvin/A...
Download Excel FINISHED Files:
people.highline.edu/mgirvin/A...
people.highline.edu/mgirvin/A...
Download pdf Notes about Power Query: people.highline.edu/mgirvin/A...
Assigned Homework:
Download Excel File with Homework: people.highline.edu/mgirvin/A...
Example of Finished Homework: people.highline.edu/mgirvin/A...
Buy excelisfun products:
teespring.com/stores/excelisf...
In this Video learn all about Excel.CurrentWorkbook Power Query Function to import all the Excel Tables in the Current Workbook, including all the potential pitfalls of using this function and how to get around these pitfalls.
Topics:
1. (00:15) Introduction to Video and to Excel.CurrentWorkbook Function, including correct definition of what Excel.CurrentWorkbook Function imports when this function is invoked.
2. (02:10) Example1: Append all Excel Tables in Current Workbook To Worksheet. We will see the Recursion Problem and solve it by filtering out the Query/Table Name.
3. (03:15) Create a Blank Query.
4. (04:10) Use Excel.CurrentWorkbook() Function as Source for Query.
5. (04:50) Use Replace feature to extract the SalesRep name from the Excel Table Name.
6. (05:38) Expand column with Excel Tables to Append all Tables into one Table.
7. (05:56) Add correct Data Types for each column
8. (06:22) Introduction to Recursion Problem, where Query will refer to itself and will double the loaded records every time a Refresh is done. And look at details of Loading Data to an Excel Worksheet after using Excel.CurrentWorkbook() Function.
9. (10:07) Solve the Recursion Problem by filtering out the Query/Table Name.
10. (11:03) Add new Excel Table to Workbook and refresh to see that new table is incorporated into Final Data Set.
11. (11:40) Look at M Code for Example #1
12. (12:20) Example2: Append all Excel Tables in Current Workbook To PivotTable Cache & make PivotTable Report. This solves the Recursion Problem because there is not a Query Load table in the Excel Worksheet as an Excel Table.
13. (12:41) Remove Excel Table that is result of Power Query Load to Worksheet by Clearing All. This process will change the Load location to Connection Only.
14. (13:38) Edit Query to Remove unneeded step and to Rename incorrectly named column.
15. (14:28) Look at M Code for Example #2
16. (15:05) Example3: Append all Excel Tables in Current Workbook that has Defined Names.
17. (15:12) Look at different objects in Excel workbook, including Excel Tables and Defined Names.
18. (17:07) Keyboard for Blank Query
19. (17:40) Use Excel.CurrentWorkbook() Function as Source for Query. Then see that this imports Excel Tables and Other Objects.
20. (17:51) Define Table Object: Set of Records for a Set of Columns/Fields.
21. (18:50) Take note that Defined Names are Imported as Tables with generic Columns Names.
22. (19:50) Learn about Table.ColumnNames Power Query Function.
23. (19:59) Filter out Filtered Database Error.
24. (20:29) Create Custom Column and use Table.ColumnNames Power Query Function to Extract Column Names from each Table in each Row.
25. (20:55) Learn about Lookup Operator or Field Access Operator to access the content for each row in a specified column.
26. (21:08) Define List Object: Ordered Sequence of Values.
27. (21:35) Learn about the Positional Index Operator that allows us to access an item in a list. Curly Brackets are the Positional Index Operator; { and } .
28. (22:27) Learn that Power Query uses Base Zero for finding Relative Positions in a List. Zero represents the first position.
29. (23:06) Filter out rows that contain “Column1”.
30. (23:18) Remove Custom Column.
31. (23:23) Rename Column
32. (23:27) Use Replace feature to extract the SalesRep name from the Excel Table Name
33. (23:41) Filter Out Query Name / Table Load Name when loading to an Excel Worksheet.
34. (24:07) Expand Columns and Change Data Types
35. (24:24) Closes and Load To Worksheet.
36. (24:46) Add new Excel Table and Refresh.
37. (25:07) Look at M Code for Example #3
38. (26:25) Talk about the non-standard Data Setup we had to deal with.
39. (26:51) Summary
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

[@timmytesla9655]

My third PowerQuery video. Now, I go do the homework. Thank you Mike!

[@excelisfun]

You are welcome, Timmy!!!

[@rodrigocustodio1955]

Mike, the minimum we can do is support you somehow, being with comments, thumbs up, or buying a shirt or something. In my opinion, you are the best at teaching excel plus all the materials you provide are really good, all your support is outstanding. I am learning so much and I am thankful for your channel.

[@otaorojuolalekan5978]

Wow! How can I like youtube videos multiple times??? You're a bomb MIKE. Words can't quantify how much I learned from you. God bless you real good.

[@excelisfun]

You are welcome! I am so glad that the videos help so much - that is why I post : ) You can quantify it by always leaving a comment and a thumbs up on each video that you watch, and your Sub too : ) I dare you to do it ; ) since the vast majority of viewers who benefit from my videos do not help with this simple task.

[@garrylingle741]

I have watched a lots of Excel videos from many different sources. I've learned a LOT about Power Query, Power Pivot, and general Excel. I still come back to your channel because I like the way you do and present things, and I still learn new things. THANK YOU doesn't really convey my appreciation for all that you've done and made available.

[@excelisfun]

You are welcome, Gary! I am happy to post and help, that is what I do. You can convey appreciation perfectly to me with a comment and thumbs up on every video that you watch, and a Sub too : )

[@shoeshines2121]

Thank you ExcelIsFun! For people watching the video, please hit "like" and leave a comment. This is easily the best channel for Excel Power Tools on KZbin!

[@sudharshanr4997]

Great video Mike! Wonderful presentation!

[@williamarthur4801]

It's so great that the files are provided so you can follow along, AND it worked.

[@excelisfun]

Always glad to help with my videos : )

[@alucc18]

Thank you Mr. Mike. I'm here after completing the EDAB series, I'm learning a lot!

[@excelisfun]

You are welcome a lot!!! : )

[@rws33369]

This channel is too crazy man.. I have tried many different sources; in written or in video forms, but this one is simply the bestest best. Thanks to the author for bringing the knowledge to us.

[@rodrigocustodio1955]

Thank you, Mike, as all your Excel videos your MSPTDA series is awesome, the truth is you are the best!

[@excelisfun]

You are welcome! Thanks for your consistent support : )

[@cakirankale]

If I don't get the concept once, second time slow and steady is enough. So amazingly explained. And when you get the usefulness of something, you feel why all are not learning it. Grateful Mike.

[@excelisfun]

So glad to help : ) : )

[@arvindmarathe8981]

I not heard about power query earlier but with your videos I understand the power quiry and how it makes work simple. Thanks you so much for this

[@excelisfun]

You are welcome, Arvind! Power Query is the great invention in Excel since the PivotTable back in the 90s : )

[@chandrathe1118]

I still come back to your MSPTDA channel to repeat the epic stuf of this serie, extrem usefull! Thanks for sharing, love the way you show and teach. Thumbs up,

[@excelisfun]

Glad you keep coming back, Chandra!!! Thanks for your support with your comment, thumbs up and Sub : )

[@ismailismaili0071]

I really love to watch your series continuously because I feel so happy with learning so many info every week. thanks as always Mr. Mike

[@excelisfun]

You are welcome so much! Glad that you are filled with new and fun info each week : )

[@alialbayati9368]

Superb as usual Mike! We cannot thank you enough for these tutorials.

[@tomr9969]

Nice session! I like MSPTDA04 & 05 because Excel.Workbook() and Excel.CurrentWorkbook() are so powerful and these are not covered in 70-779 Exam Ref but I have heard you can expect to see these on the exam certifications. I love these videos! On to MSPTDA06. Thanks again!

[@chavelooo33]

For me this guy is like Messi or Cr Ronaldo. You are the best. Explaining, teaching and so on. I am so interested to continue learning.

[@1877Pegasus]

I am running off of adjectives of appreciation of your amazing job. Clear, concise, well structured, with downloadable files and notes... It is just hard to believed the quality of your youtube courses. THANK YOU SO MUCH!!

[@excelisfun]

Yes!!!!! That is why I post: to help provide quality Education to the world for free. Except, I do charge a comment and thumbs up for each video : )

[@frisovandermeulen1613]

I don’t know how much time and frustrations you saved me with your explanation of the rucursive problem; I can imagine clearly the proces I would have gone through if I did not see this lesson. Thanks a lot!

[@excelisfun]

You are welcome a lot, Friso ver der Meulen !!! Once you understand the underlying issue, it is not too hard to deal with. Thanks for your support with your comment, Thumbs Up and of course for your Sub : )

[@fmohiy]

One of best teachers ever. Never a dropped step or ever wondering how you got from one step to another. You deserve more recognition. God bless you.

[@excelisfun]

You are right about more recognition. But when you don't market these days, you don't get status. But I still pump out free quality education since 2008. I have to just be happy with the consistency , and the people like you how find this : )

[@elactecnology]

Each day refreshing Power Query. I highly recommend for anyone working in Audit and Accounting. Power query will make working with GL Listing even easier😊. A friend of mine just called it a magic.

[@iankr]

Excellent! I'm finally getting around to learning Power Query properly, having just dabbled with it occasionally for work. I'm working my way through your MSPTDA videos, which are proving invaluable. I like your delivery style, which covers things logically and methodically. Warm greetings from London, UK.

[@excelisfun]

I am glad to help you. There is no doubt that knowing Power Query well, is a huge value added to any employee, and it makes the work more fun : )

[@gregfollett8285]

I love, love loved this video. I have learned so much from watching your FREE online courses, I am using it on the job and impressing my boss. Thank you Mike, you're amazing!

[@excelisfun]

You are so welcome!!!!! But they are NOT free lol I do charge a thumbs up on each video!!!!!

[@thaonguyenthu7726]

You're the best of the best, Mr. Mike Excelisfun Girvin. Thank you so much!

[@excelisfun]

You are welcome so much, Thao Ngyen Thu!!!! Thank you for your support on each video that you learn from : )

[@armondnazarian4455]

The amount of knowledge you teach in your videos in a short period of time is amazing! :) Thanks

[@excelisfun]

Did you check out the pdf notes too? Sometimes the pdf notes are even better : ) Thanks for your support on each vid, Armond!

[@armondnazarian4455]

@@excelisfun Yes I download everything and read and practice them. Thanks :)

[@andrewhirst2944]

I always come back to your videos, working through the MSPTDA series to the end. I find your training invaluable as where I work as A Data Analyst in the UK no training is provided!!. All the best.

[@excelisfun]

Yes, sir! That had been my goal for the past 12 years: Since most employees in the world do not have the skills and academia and business do not train properly, I try to provide free Excel Education for the world for those who want to learn : )

[@excelisfun]

Thanks for your support of my efforts with comments and thumbs ups on every video that you learn from : )

[@andrewhirst2944]

@@excelisfun And you are doing a great job, just finished MSPTDA 8 doing No 9 tomorrow morning UK time, looking forward to the part on SQL intigration which I know myself (again self taught). Regards Andrew

[@excelisfun]

@@andrewhirst2944 Yes!!!!!!

[@sandip_bettereveryday]

Learnt a lot. For me the highlight of the video or the 'light bulb' moment was when you explained how to use "positional index operator" in Power Query!

[@excelisfun]

Cool, glad the Positional Index Operator was helpful!!!! Thank you for the support, Sandip Mukherjee, with your comment, Thumbs Up and Sub : )

[@kosalanef]

Thank you very much again for sharing your knowledge... Even the printed versions are very much helpful. Im learning them like im in a class...Everyday spending some time to learn these lectures. Hats off to an amazing human being.

[@excelisfun]

That is what I like to do: post full free classes for the world to learn and have fun!!!!! It is all worth it with your consistent support on each video, Asantha!!!!!

[@anisdadani8980]

Masha Allah , you are doing great work. May Allah (SWT) less you with best.

[@barttitulaerexcelbart9400]

Thanks Mike. Besides many steps I appreciated that you used the help page of microsoft. Even if this page is made fot IT tech guys and not for Excel business people, it is a good start. Hope you do this in your future videos as well.

[@excelisfun]

I will, and I have done it in many Power Query videos in the past too; but... the help for some of the functions, like Excel.CurrentWorkbook is terribly wrong. So we have to be careful with Microsoft help... : ( Thanks for your support, Bart : )

[@fluorine121]

Followed for 7 years. Watched and Learnt a great deal from you @ExcelIsFun. Your remarkable dedication and contribution for the those who want to be more proficient in Excel go above and beyond! Thank you & Thank you

[@excelisfun]

You are welcome, Fluorine!!

[@wayneedmondson1065]

Hi Mike.. thanks for this deeper dive into Excel.CurrentWorkbook and how to trap and solve for recursion and extraneous objects that get swept into the query when using it. The tips and techniques are Gold! Much appreciated .Thumbs up!

[@excelisfun]

Thanks, Wayne : ) I really appreciate great Teammates like you : )

[@wayneedmondson1065]

@@excelisfun Thanks Mike.. I learn something new from you every day.. and have fun doing it! Thanks for all that you do : )

[@excelisfun]

@@wayneedmondson1065 You are welcome, Wayne!

[@rodrigocustodio1955]

Mike, lets put it simple, you are the best Excel teacher, and in my opinion, it is undisputable :)

[@excelisfun]

Thank you for your kind words!!!

[@jazzista1967]

Great powerquery series.. look forward to the rest of the videos of MSPTDA.. Thanks Mike

[@excelisfun]

There will be many over the next 6 - 9 months : )

[@dorissweanapo9860]

You make MSPTDA so fun and easy to learn :)

[@excelisfun]

Glad it helps and is fun, Doris!!!!!

[@jackeroo75]

This guy would be great at the office with his colorful and user friendly design! U rock man!

[@excelisfun]

I hope you liked the video and it was useful, jackeroo75

[@pravinshingadia7337]

Thanks Mike. The more I learn from you the more I realise how little I actually know!

[@excelisfun]

Me too, me too!!!!!! The more I learn to teach you and our other Teammates, the less I know too. But it is always helpful, useful and quite delicious to keep learning more : ) : ) : )

[@rizalynayen1357]

This is definitely what I really need. Thank you for explaining

[@davidsheman]

Way more efficient than what I was doing before! Thanks as always!

[@excelisfun]

Yes! I love to hear that you are learn more efficient methods : ) Thanks for the support with your comment and thumbs up, David!

[@KR-good]

Thanks for another awesome video. I love Power Query more and more each day.

[@excelisfun]

Yes the love does build day by day as PQ reveals how amazing it is!!!! Thanks for your support, K R!!!!

[@gdecome]

Great video Mike ... easy to understand how functions work step-by-step. One thing that I use all the time is an update in the code to read named ranges in PQ, in general, one single cell to be used as a variable. MyVariable = Excel.CurrentWorkbook(){[Name="MyName"]}[Content]{0}[Column1], where 'MyName" is how the cell in named in Excel and 'MyVariable' is the reference to be used in PQ for filtering, comparisons, etc. Really very useful. Again, thanks for sharing such amazing tips & tricks

[@excelisfun]

Yes, that is a great trick and I have videos on that topic posted, AND, without a doubt, that is coming in this series. However, I have always done it as a single criteria, like product name, or date. Are you saying that you put the entire formula in an Excel cell as a variable, like: Excel.CurrentWorkbook(){[Name="MyName"]}[Content]{0}[Column1]? Thanks for the support, Gilbert : )

[@gdecome]

ExcelIsFun No, that formula is not in Excel but in PQ. What I meant is it could give you a lot of flexibility accessing a named cell in Excel as that cell could be result of a formula, VBA or even a simple value. Looking forward for your new videos! Thank you

[@excelisfun]

Got it : ) Much more to come : )

[@sasavienne]

Thanks Mike. 👍 Every single tutorial from you is a masterpiece. Excel without you is like a piano without a pianist. Best regards. Salim

[@excelisfun]

Thanks, Salim : ) Thanks for the cool simile, metaphor : )

[@sasavienne]

@@excelisfun You are welcome Mike. I applied all these steps on my PC and yes you are the best Excel teacher.... Thanks.. 🌟 🌟 🌟

[@vasilisa6128]

Thank you, Mike! It's a great video. You make me to dream to become such a great expert like you one day!

[@excelisfun]

You can do it, Vasilisa!!!!!

[@nattawut_chatwiriyacharoen]

Thanks a lot, Mike I used to face something like this but solved it by using Append Query command. However, I had to add SalesRep name of each table manually, and had to put all tables into Power Query one by one. Your solution, Excel.CurrentWorkbook(), is great. Moreover, you also mentioned about recursion problem and problem regarding to other objects in Excel. It's so cool.

[@excelisfun]

Yes!!!!! I am glad that it is cool for you, Nattawut : ) This why I post my classes here for free at KZbin - so we can all learn and have fun !!! Have you been posting these videos at your Facebook page, or just the #2 video?

[@nattawut_chatwiriyacharoen]

For this series, I posted only Video#2 to my facebook fanpage. Recently, I posted EMT1449 and EMT1498, and feedback was good as well, lots of Likes & Shares. You can see them from below URL. facebook.com/reportingengineer/posts/2146468838929556 facebook.com/reportingengineer/posts/2143995985843508?__tn__=K-R

[@excelisfun]

Thank you very much for your support and sharing, Nattawut!!!! Video #9 in this series (the most epic video yet) will be out later today : )

[@MrNinjagofan]

Awesome video again! I learn a lot from you Mike!

[@adin4417]

Your videos make my day!! Love the way you present and explain eventhough a little bit slow for me 😁

[@excelisfun]

Glad they help. You can run the video at 1.5 times speed ; )

[@excelisfun]

Thanks for your support with your thumbs ups and comments : )

[@DIGITAL_COOKING]

wow!!;..........; totally unbelievable when you start to understand power query it is one of a great tool Microsoft ever made; the best thing I did is to restart watching this series for the second time, and I will do it again I know maybe i bother you by may coments mike, but it's My way of expression about the feeling; about the happiness when I understand when getting somthing new; you convince me that EXCEL is the ultimate tool for business, I trust your knowledge :)

[@excelisfun]

100% no bother!!!! Comment a lot - it helps promotr the videos. Comment to say thanks or ask a question. If I don't know the answer I will say so : )

[@excelisfun]

Yes, Excel is the ultimate tool for business!!!!

[@romanguz]

Amazing learnings, thank you so much!

[@MalinaC]

Amazing, as always. Power Query is really, really FUN!

[@excelisfun]

Really, really fun!!! Thanks, Teammate!

[@MalinaC]

:)

[@Sal_A]

Positional Index Operator - there is something you don't hear every day. Thanks for the excellent tutorial.

[@excelisfun]

You are welcome for the video, long time Teammate, Sal A!!!!!

[@hiteshjoshi3148]

It Feels privileged and weird at the same time that only 58k people have seen the video. Thanks Again.

[@excelisfun]

Ya, it is weird. There is NO other free Power Pivot / Power Query/ BI class on the internet that is as complete as this. But few want to watch ... : (

[@user-hz4ff2fs9m]

Very clear and good for study,the lesson is very fast and I need to go back many times.I learn A lot from this Vidio thanks.

[@excelisfun]

Glad it is good for you. Sorry it is fast, but luckily there is a rewind button : )

[@scottgaines2677]

Another Great video Mike! Lots of information to absorb!

[@excelisfun]

Glad it is great for you, Scott! Thank you for the comment, Thumbs Up and Sub : )

[@cezaryczajka9198]

Great advice, thank you !!!. Certainly they will be useful in practice.

[@excelisfun]

Not the full Data Model with proper database sources, but sometimes this is what we have! Thanks for the support, Cezary, with your comment, Thumbs Up and Sub : )

[@garyingle7440]

Thank you Mike, your videos are brilliant!

[@excelisfun]

Glad they help, Gary!!!! Thanks for your support with comments, thumbs ups and your Sub : )

[@rfeyman3682]

Love this series even thought I am a bit torn. Guess I have to rebuild some of my old Excel spreadsheets, the ones with crazy array formulas. Heck, I even hit Excel's formula limit building one particularly tricky array formula and yes the decision tree was that complex.

[@excelisfun]

I am like you - I have to re-do some spreadsheets. But, the GREAT news is that Excel Formulas, Power Query and Power Pivot DAX and Power BI Desktop DAX all have there place and good use - and I am just so happy that I have more and better tools now : ) Thanks for the support, R Feyman : )

[@excelworx8712]

wow, your PQ training is really heating up! going to MSPTDA 06 now

[@excelisfun]

Awesome, Rajan!!!!

[@kss2066]

Thank you for this class!

[@EricaDyson]

Brilliant explanation. Thanks ever so. Learned a lot here... trully.

[@excelisfun]

You are welcome, Erica : ) : )

[@himanshudalai1028]

Thank you Mike for this awesome video. Great learning.

[@excelisfun]

You are welcome for the video, HIMANSHU!!!! Thank you very much for your support on each video that you watch : )

[@vktyagi11]

Mike, you can add blank query to quick access toolbar. will help to reduce long keys shortcuts.

[@HopeCastle2000]

Exactly what I was looking for! Thank you!

[@excelisfun]

You are welcome, Hope! Thanks for your support : )

[@mohitmanwani5298]

AMAZING STUFF MIKE!!!

[@patrickbanzon7145]

Great Video as always Professor Mike :)

[@mazarata73]

Another great tutorial. Thanks very much Mike.

[@excelisfun]

You are welcome, Giuseepe!!! Thank you very much for your support : )

[@Pat14922]

Good Video, I know I'm learning as this time my Query did not return what I expect , and I was able to walk back through it and find out what the problem was . Thanks Mike !

[@excelisfun]

You are welcome, Peter! Thanks for your support on each video : )

[@871340730]

Thank you very much Mike! I just can't thank you enough!

[@excelisfun]

Just give me a thumbs up and comment on each video you learn from, and of course your Sub... thank is thanks enough : ) And of course, you are welcome, Shehan !

[@msantosh1220]

Hey Mike, On the new Power Query Editor Miscroft has enabled intellisense option you just type few starting key word and intellisense gives you all possible option for that keys.

[@zeshanful]

Keep it up Man. its such a great source

[@pollo_ragg5080]

Thank you for the videos. Really good work. Keep positing do..

[@DIGITAL_COOKING]

great !!, great mike !!!, now I start to improve and get the idea just question at 14min: 55 you said " is the best to load at the cash,...can't understand why is best because we can load it in the data model so what is the difference between cash and the data model?

[@DigitalCraig]

Enjoying the MSPTDA series

[@excelisfun]

Glad you are enjoying it! Thanks for the support : )

[@hichamhadj9640]

Simply amazing, thank you!

[@knikl]

Waw just Waw!!! Thank you so much, this is amazing.

[@shinujoshi4998]

Hi i am from India and thank you so much for your amazing classes... I used to watch these sessions to learn about PQ..now i got one automation assignment using PQ... Can I connect with you to get some clarification...

[@entertainmentgalaxy971]

Thanks for sharing Table.Columnnames function.... .. PQ is Fun...

[@excelisfun]

Yes!!!!!! PQ is fun! Thanks for your consistent support, Haider : )

[@mattschoular8844]

Great video Mike. Thank you

[@excelisfun]

You are welcome, Scott!!! Thanks for the support!!!

[@ahmadashry1812]

Seriously, you are amazing

[@ftmagicart]

Excellent tutorial. Thank you very much.

[@excelisfun]

You are welcome very much, FT Magic Art !!!

[@thiernoibrahimadiallo7740]

Great vidéo as usual . Recursion pb cool

[@excelisfun]

Glad it is great for you, Thierno!!! Thanks for the support : )

[@filipsvakjaroski20]

Very useful examples, Thank you Mike!

[@excelisfun]

You are welcome, Filip!!! Gotta be careful when using Excel.CurrentWorkbook : )

[@filipsvakjaroski20]

@@excelisfun It's smart to always use column filtering to avoid recursion problem, thank you for your insight on this issue.

[@excelisfun]

@@filipsvakjaroski20 Once you relize that this must be done every time, it is such an easy step to do, but if you don't know about strange behavior, it is terrible...

[@mirrrvelll5164]

Amazing as always. Mike, question; correct me if I am wrong (probably I missed it in some lectures of you), I noticed that you are using text filter in PQeditor (begins with or ends with etc..) when wanna filter/remove something from column. Is it (does is make) difference if you just click on arrow down in certain column and simply "uncheck" the things we dont need??

[@mohamedchakroun4973]

10/10 Mike for this excelcurrentworkbook😃😃😃😃

[@excelisfun]

You are welcome! Thanks for the 10/10 !!!!!!

[@johnborg5419]

Great!!! Downloading and practicing. :) :) Thanks Mike.

[@excelisfun]

Yes!!!! John Borg, you are getting good with Power Query : )

[@johnborg5419]

@@excelisfun Not so Fast my Dear Friend :) :) (although i already did some jobs with power query at my work.) Thanks to you Of course!!!

[@excelisfun]

@@johnborg5419 Okay< getting good with Power Query, slowly ; )

[@elactecnology]

Hi Mike, After this series of MSPTDA Videos. Which Power query playlist would you recommend me to watch?

[@chrism9037]

Great work Mike!!

[@excelisfun]

Thanks, Chris! Glad you like it : )

[@TouchdownHouse]

Fantastic Video. Thanks.

[@johnborg6005]

Thanks Mike. Really Amazing!!! :) :)

[@excelisfun]

Glad you like it, John! Thanks for your support as always : )

[@Victor-ol1lo]

Great video !!! Thanks Mike !!

[@excelisfun]

You are welcome, Victor!!! Thanks for the support : )

[@linelson]

Very good, this playlist is amazing! thanks

[@excelisfun]

Glad you like it, lineson!!! Thanks for the support with your comment, Thumbs Up and Subscription. I can keep going making more videos for this series with consistent support from viewers like you. BTW, this series has at least 50 more videos and will be (hopefully) more than amazing : )

[@linelson]

ooohh yeah! I love power query.

[@excelisfun]

Much more fun to come : ) : ) : )

[@kamranb1369]

Thanks Mike.Great video

[@excelisfun]

You are welcome, K B !!! Thanks for the consistent support : )

[@DougHExcel]

Recursion...ugh...it can get ya with PQ....Thanks for the video :-D

[@excelisfun]

You are welcome, Teammate!

[@prasad9976]

Nicely explained thank you sir

[@dayanacaceres128]

You have gotten my heart Mike

[@excelisfun]

Glad to help out, Dayana!!! Thanks for your support with your comment, thumbs up and of course your Sub : ) : )

[@shubhampawar8506]

You are the best ❤️

[@excelisfun]

Thank you, shubham : )

[@elactecnology]

#Wow. So WonderFul. That's amazing

[@excelisfun]

Yes, a lot in this one including recursion!

[@tanweerabbasabbas649]

my great teacher. next video you make make it with your video too not just voice.🥰

[@stevennye5075]

very clear explanations

[@excelisfun]

Glad it is clear for you, Steven!!! Thanks for the support!!!!

[@herrsan]

ok, I have watched this segment multiple times now but I still don't get it. Why is there this additional row Sheet6!ExternalData_1 in 9:36? Can anyone please explain?

[@markmathews91]

great stuff. thank you

[@excelisfun]

You are welcome, Mark!