Wine Shop Owner, art lover, Power Query enthusiast.Erik Svensen has been blogging about Power Query before it was called Power Query! YouTube version:  https://youtu.be/y5XV6-FXOKk Check out Erik's links Filter a table based on another How to handle different decimal separators  LinkedIn: https://www.linkedin.com/in/eriksvensen/Twitter: https://twitter.com/donsvensen

Wine Shop Owner, art lover, Power Query enthusiast. Erik Svensen has been blogging about Power Query before it was called Power Query! YouTube version:  <a href="https://youtu.be/y5XV6-FXOKk" rel="nofollow" target="_blank">https://youtu.be/y5XV6-FXOKk</a> Check out Erik's links <a href="https://eriksvensen.wordpress.com/2017/12/12/powerquery-filter-a-table-based-on-another-table-column-or-list-and-some-filter-ahas/" rel="nofollow" target="_blank">Filter a table based on another</a> <a href="https://eriksvensen.wordpress.com/2018/07/02/powerquery-how-to-handle-different-decimal-separator-when-importing-csv-files/" rel="nofollow" target="_blank">How to handle different decimal separators</a> LinkedIn: <a href="https://www.linkedin.com/in/eriksvensen/" rel="nofollow" target="_blank">https://www.linkedin.com/in/eriksvensen/</a> Twitter: <a href="https://twitter.com/donsvensen" rel="nofollow" target="_blank">https://twitter.com/donsvensen</a>

The One with Erik Svensen

As always I thoroughly enjoyed chatting with my guest.  Thank you Celia.Celia has a very different backstory to many guests, such a twisting tale of chance and hard work coupled with a dedication to automate everything and find a better way.Check out Celia's favourite and extremely useful blog post on allowing a single refresh when combining loaded tables with Pivot tables  https://youtu.be/JCNSVWY2NYw https://solveandexcel.ca/2020/09/11/enable-background-refresh-property-in-power-query-in-excel/    And her most popular here https://youtu.be/OQE9qMbofCw https://solveandexcel.ca/2020/10/23/how-to-change-the-display-language-in-excel/    You can also find Celia here: https://www.linkedin.com/in/celiajordaoalves/ https://twitter.com/celia_excelThe Dataflow Connector code I mention briefly is = PowerPlatform.Dataflows(null)

As always I thoroughly enjoyed chatting with my guest.  Thank you Celia. Celia has a very different backstory to many guests, such a twisting tale of chance and hard work coupled with a dedication to automate everything and find a better way. Check out Celia's favourite and extremely useful blog post on allowing a single refresh when combining loaded tables with Pivot tables  <a href="https://youtu.be/JCNSVWY2NYw" rel="nofollow" target="_blank">https://youtu.be/JCNSVWY2NYw</a> <a href="https://solveandexcel.ca/2020/09/11/enable-background-refresh-property-in-power-query-in-excel/" rel="nofollow" target="_blank">https://solveandexcel.ca/2020/09/11/enable-background-refresh-property-in-power-query-in-excel/</a> And her most popular here <a href="https://youtu.be/OQE9qMbofCw" rel="nofollow" target="_blank">https://youtu.be/OQE9qMbofCw</a> <a href="https://solveandexcel.ca/2020/10/23/how-to-change-the-display-language-in-excel/" rel="nofollow" target="_blank">https://solveandexcel.ca/2020/10/23/how-to-change-the-display-language-in-excel/</a> You can also find Celia here: <a href="https://www.linkedin.com/in/celiajordaoalves/" rel="nofollow" target="_blank">https://www.linkedin.com/in/celiajordaoalves/</a> <a href="https://twitter.com/celia_excel" rel="nofollow" target="_blank">https://twitter.com/celia_excel</a> The Dataflow Connector code I mention briefly is = PowerPlatform.Dataflows(null)

The One with Celia Alves

I'm a big fan of Chandeep's YouTube videos, his Power Query content is thoughtful and well explained.  I often discover he's covered topics 12 months before I do which is annoying! :) I really enjoyed our wide-ranging chat. Ideas we mention at the end Customisable Ribbon in Power Query  Expandable Power Query Formula BarThe YouTube version of this chat is here https://youtu.be/8IOA18yzDGA  You can find Chandeep via his excellent YouTube channel https://www.youtube.com/c/GoodlyChandeep  Favourite Blog: Recruitment Dashboard in Power BI - https://www.goodly.co.in/recruitment-tracker-dashboard-template/    Most Popular: Combine Data from Multiple Excel Files - https://www.youtube.com/watch?v=_jegiQkyC3s   Find Chandeep here: Blog - https://www.goodly.co.in/blog/  YouTube - https://www.youtube.com/goodlychandeep LinkedIn - https://www.linkedin.com/in/chandeepchhabra/  Twitter - https://twitter.com/chandeep2786

I'm a big fan of Chandeep's YouTube videos, his Power Query content is thoughtful and well explained.  I often discover he's covered topics 12 months before I do which is annoying! :) I really enjoyed our wide-ranging chat. Ideas we mention at the end <a href="https://ideas.powerbi.com/ideas/idea/?ideaid=f28c0988-bb88-433e-9b32-cf881993b7e6" rel="nofollow" target="_blank">Customisable Ribbon in Power Query</a> <a href="https://ideas.powerbi.com/ideas/idea/?ideaid=ac73e0b4-e1d8-ec11-bea1-501ac50a5d5c" rel="nofollow" target="_blank">Expandable Power Query Formula Bar</a> The YouTube version of this chat is here <a href="https://youtu.be/8IOA18yzDGA" rel="nofollow" target="_blank">https://youtu.be/8IOA18yzDGA</a> You can find Chandeep via his excellent YouTube channel <a href="https://www.youtube.com/c/GoodlyChandeep" rel="nofollow" target="_blank">https://www.youtube.com/c/GoodlyChandeep </a> Favourite Blog: Recruitment Dashboard in Power BI - <a href="https://www.goodly.co.in/recruitment-tracker-dashboard-template/" rel="nofollow" target="_blank">https://www.goodly.co.in/recruitment-tracker-dashboard-template/ </a> Most Popular: Combine Data from Multiple Excel Files - <a href="https://www.youtube.com/watch?v=_jegiQkyC3s" rel="nofollow" target="_blank">https://www.youtube.com/watch?v=_jegiQkyC3s</a> Find Chandeep here: <ul><li>Blog - <a href="https://www.goodly.co.in/blog/" rel="nofollow" target="_blank">https://www.goodly.co.in/blog/ </a></li> <li>YouTube - <a href="https://www.youtube.com/goodlychandeep" rel="nofollow" target="_blank">https://www.youtube.com/goodlychandeep</a></li> <li>LinkedIn - <a href="https://www.linkedin.com/in/chandeepchhabra/" rel="nofollow" target="_blank">https://www.linkedin.com/in/chandeepchhabra/ </a></li> <li>Twitter - <a href="https://twitter.com/chandeep2786" rel="nofollow" target="_blank">https://twitter.com/chandeep2786</a></li></ul>

The One with Chandeep Chhabra

"Just get it done" - the unofficial Power Query motto Ed is a Principal Consultant at P3 Adaptive From life as a CPA to providing more than 1,000 solutions to the Power BI Community, Ed has been on the Power Query / Power Pivot / Power BI journey from the start.   Ed's post on the P3 blog about lists can be found here: https://p3adaptive.com/2022/03/working-with-lists-in-power-query-lets-count-words/  Favourite Blog: https://www.ehansalytics.com/blog/2021/6/12/working-with-multiple-row-headers-from-excel-in-power-query Most Popular: https://www.ehansalytics.com/blog/2020/7/16/return-row-based-on-max-value-from-one-column-when-grouping You can find Ed here https://www.linkedin.com/in/edhansberry/ and on twitter: https://twitter.com/ehansalytics

"Just get it done" - the unofficial Power Query motto Ed is a Principal Consultant at P3 Adaptive From life as a CPA to providing more than 1,000 solutions to the Power BI Community, Ed has been on the Power Query / Power Pivot / Power BI journey from the start. Ed's post on the P3 blog about lists can be found here: <a href="https://p3adaptive.com/2022/03/working-with-lists-in-power-query-lets-count-words/" rel="nofollow" target="_blank">https://p3adaptive.com/2022/03/working-with-lists-in-power-query-lets-count-words/ </a> Favourite Blog: <a href="https://www.ehansalytics.com/blog/2021/6/12/working-with-multiple-row-headers-from-excel-in-power-query" rel="nofollow" target="_blank">https://www.ehansalytics.com/blog/2021/6/12/working-with-multiple-row-headers-from-excel-in-power-query</a> Most Popular: <a href="https://www.ehansalytics.com/blog/2020/7/16/return-row-based-on-max-value-from-one-column-when-grouping" rel="nofollow" target="_blank">https://www.ehansalytics.com/blog/2020/7/16/return-row-based-on-max-value-from-one-column-when-grouping</a> You can find Ed here <a href="https://www.linkedin.com/in/edhansberry/" rel="nofollow" target="_blank">https://www.linkedin.com/in/edhansberry/</a> and on twitter: <a href="https://twitter.com/ehansalytics" rel="nofollow" target="_blank">https://twitter.com/ehansalytics</a>

The One with Ed Hansberry

Miguel Llopis

Miguel is Group Product Manager, Citizen Data Integration @ Microsoft He has been on the Power Query development journey since it's early inception as codename Data Explorer, and was involved in the original development of the Power Query user interface that we all know and love. He's now running the team and is more coach than player these days. It was fantastic to chat to Miguel about all things Power Query and try out the new game - Just a "M"inute   You can find Miguel here https://www.linkedin.com/in/migllopis/   and check out all things Power Query via https://powerquery.microsoft.com/en-us/   and the relatively new twitter handle https://twitter.com/MSPowerQuery 

Miguel is Group Product Manager, Citizen Data Integration @ Microsoft He has been on the Power Query development journey since it's early inception as codename Data Explorer, and was involved in the original development of the Power Query user interface that we all know and love. He's now running the team and is more coach than player these days. It was fantastic to chat to Miguel about all things Power Query and try out the new game - Just a "M"inute You can find Miguel here <a href="https://www.linkedin.com/in/migllopis/" rel="nofollow" target="_blank">https://www.linkedin.com/in/migllopis/</a>   and check out all things Power Query via <a href="https://powerquery.microsoft.com/en-us/" rel="nofollow" target="_blank">https://powerquery.microsoft.com/en-us/</a>   and the relatively new twitter handle <a href="https://twitter.com/MSPowerQuery" rel="nofollow" target="_blank">https://twitter.com/MSPowerQuery</a>

The One with Miguel Llopis

YouTube version: https://youtu.be/6GL4U4pkWeI Imke looks at M code like Neo sees the "M"atrix.   She is one of those folks that just amazes me as to what is possible inside Power Query and the M language.   Imke has made a huge contribution already to the various tech community forums and continues to do so by now developing some amazing tools to make all our Power BI development lives easier.   https://www.thebiccountant.com/about/   Imke's favourite tool: Power BI Cleaner Gen2 now covers Analysis Services Models as well (thebiccountant.com) Most popular article:  Easy Profit and Loss and account scheme reports DAX PowerBI Pivot (thebiccountant.com)   Advanced algorithms: Goal seek algorithm: Non-linear Break-Even Analysis in PowerBI – The BIccountant Matrix Inversion (MINVERSE Excel-function): Returns the inverse matrix for a matrix stored in an array. As a bonus, its determinant is returned in the metadata. (github.com)   Ben Gribaudo Series Power Query M Primer (part 1): Introduction, Simple Expressions &amp; let | Ben Gribaudo

YouTube version: <a href="https://youtu.be/6GL4U4pkWeI" rel="nofollow" target="_blank">https://youtu.be/6GL4U4pkWeI</a> Imke looks at M code like Neo sees the "M"atrix.   She is one of those folks that just amazes me as to what is possible inside Power Query and the M language. Imke has made a huge contribution already to the various tech community forums and continues to do so by now developing some amazing tools to make all our Power BI development lives easier. <a href="https://www.thebiccountant.com/about/" rel="nofollow" target="_blank">https://www.thebiccountant.com/about/</a> Imke's favourite tool: <a href="https://www.thebiccountant.com/2021/08/23/power-bi-cleaner-gen2-now-covers-analysis-services-models-as-well/" rel="nofollow" target="_blank">Power BI Cleaner Gen2 now covers Analysis Services Models as well (thebiccountant.com)</a> Most popular article:  <a href="https://www.thebiccountant.com/2016/07/21/easy-profit-loss-account-scheme-reports-power-bi-power-pivot-dax/" rel="nofollow" target="_blank">Easy Profit and Loss and account scheme reports DAX PowerBI Pivot (thebiccountant.com)</a> Advanced algorithms: Goal seek algorithm: <a href="https://www.thebiccountant.com/2017/07/11/non-linear-break-even-analysis-in-powerbi/" rel="nofollow" target="_blank">Non-linear Break-Even Analysis in PowerBI – The BIccountant</a> Matrix Inversion (MINVERSE Excel-function): <a href="https://gist.github.com/ImkeF/b58537f9469fd125e0179c0c86facac0" rel="nofollow" target="_blank">Returns the inverse matrix for a matrix stored in an array. As a bonus, its determinant is returned in the metadata. (github.com)</a> Ben Gribaudo Series <a href="https://bengribaudo.com/blog/2017/11/17/4107/power-query-m-primer-part1-introduction-simple-expressions-let" rel="nofollow" target="_blank">Power Query M Primer (part 1): Introduction, Simple Expressions &amp; let | Ben Gribaudo</a>

The One with Imke Feldmann

Alex Powers

The Power Query Magic YouTube version is available here... https://youtu.be/AWuWwxGs3lo Alex Powers is a passionate Power Query advocate who has trained thousands of people in Power BI and now works for Microsoft helping to spread the word that Power Query is Magic! We have a wide ranging conversation, agreeing that Tables are the key to it all. I raise my wariness of "AI" driven help, Alex battles with whether to restart a blog, and of course we discuss Query Folding.   30 Day Challenge: Query Folding - #30DQuery - https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N   Power BI Workshops - https://aka.ms/pbiworkshops

The Power Query Magic YouTube version is available here... <a href="https://youtu.be/AWuWwxGs3lo" rel="nofollow" target="_blank">https://youtu.be/AWuWwxGs3lo</a> Alex Powers is a passionate Power Query advocate who has trained thousands of people in Power BI and now works for Microsoft helping to spread the word that Power Query is Magic! We have a wide ranging conversation, agreeing that Tables are the key to it all. I raise my wariness of "AI" driven help, Alex battles with whether to restart a blog, and of course we discuss Query Folding. 30 Day Challenge: Query Folding - #30DQuery - <a href="https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N" rel="nofollow" target="_blank">https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N</a> Power BI Workshops - <a href="https://aka.ms/pbiworkshops" rel="nofollow" target="_blank">https://aka.ms/pbiworkshops</a>

The One with Alex Powers

Reza Rad

The Power Query Magic YouTube version is available here... https://youtu.be/OKKAwlUIUW4 Reza Rad is a flamenco guitar playing Power BI community "stalwart". Look up the definition of the word "stalwart" and you'll find something like this "a dedicated, reliable, and hard-working supporter of an organization or team" .  This is Reza, he contributes to the Power BI community in so many ways I question when he has time to sleep! Reza was one of the first to blog about the early versions of Power BI, we touch on SSIS and discuss what a "Microsoft Regional Director" role involves - it's not what you'd think.   Links:   Website: Home - RADACAD Most Popular Article https://radacad.com/append-vs-merge-in-power-bi-and-power-query Favourite Articles: https://radacad.com/grouping-in-power-query-getting-the-last-item-in-each-group

The Power Query Magic YouTube version is available here...<a href="https://youtu.be/OKKAwlUIUW4" rel="nofollow" target="_blank"> https://youtu.be/OKKAwlUIUW4</a> Reza Rad is a flamenco guitar playing Power BI community "stalwart". Look up the definition of the word "stalwart" and you'll find something like this "a dedicated, reliable, and hard-working supporter of an organization or team" .  This is Reza, he contributes to the Power BI community in so many ways I question when he has time to sleep! Reza was one of the first to blog about the early versions of Power BI, we touch on SSIS and discuss what a "Microsoft Regional Director" role involves - it's not what you'd think. Links: Website: <a href="https://radacad.com/" rel="nofollow" target="_blank">Home - RADACAD</a> Most Popular Article <a href="https://radacad.com/append-vs-merge-in-power-bi-and-power-query" rel="nofollow" target="_blank">https://radacad.com/append-vs-merge-in-power-bi-and-power-query</a> Favourite Articles: <a href="https://radacad.com/grouping-in-power-query-getting-the-last-item-in-each-group" rel="nofollow" target="_blank">https://radacad.com/grouping-in-power-query-getting-the-last-item-in-each-group</a>

The One with  Reza Rad

The Power Query Magic YouTube version is available here... https://youtu.be/07zOX5IYImI   Gil is author of the excellent book Collect, Combine, and Transform Data Using Power Query in Excel and Power BI https://datachant.com/next/    We discuss Gil's experience as one of the Program Managers on the Excel team where he was closely involved with Power Query in it's earliest days.   We discover one of Gil's first ever blog posts was the inspiration for my first ever YouTube video Gil's post: https://p3adaptive.com/2015/05/harness-power-query-to-gain-competitive-analysis-insights-from-linkedin/ My Video: https://youtu.be/uej_Uc3__bE  Links:   Gil's App Source Apps: https://appsource.microsoft.com/en-us/marketplace/apps?page=1&amp;search=datachant   Most Popular Article https://datachant.com/2016/12/09/remove-empty-columns-rows-from-table-in-excel-power-query/ Favourite Articles: https://datachant.com/2019/10/17/bad-practices-power-bi-pie-charts/ https://datachant.com/2017/01/06/10-mistakes-you-always-do-in-powerbi-powerquery/

The Power Query Magic YouTube version is available here... <a href="https://youtu.be/07zOX5IYImI" rel="nofollow" target="_blank">https://youtu.be/07zOX5IYImI</a> Gil is author of the excellent book Collect, Combine, and Transform Data Using Power Query in Excel and Power BI <a href="https://datachant.com/next/" rel="nofollow" target="_blank">https://datachant.com/next/ </a> We discuss Gil's experience as one of the Program Managers on the Excel team where he was closely involved with Power Query in it's earliest days. We discover one of Gil's first ever blog posts was the inspiration for my first ever YouTube video Gil's post: <a href="https://p3adaptive.com/2015/05/harness-power-query-to-gain-competitive-analysis-insights-from-linkedin/" rel="nofollow" target="_blank">https://p3adaptive.com/2015/05/harness-power-query-to-gain-competitive-analysis-insights-from-linkedin/</a> My Video: <a href="https://youtu.be/uej_Uc3__bE" rel="nofollow" target="_blank">https://youtu.be/uej_Uc3__bE</a> Links: Gil's App Source Apps: <a href="https://appsource.microsoft.com/en-us/marketplace/apps?page=1&amp;search=datachant" rel="nofollow" target="_blank">https://appsource.microsoft.com/en-us/marketplace/apps?page=1&amp;search=datachant</a> Most Popular Article <a href="https://datachant.com/2016/12/09/remove-empty-columns-rows-from-table-in-excel-power-query/" rel="nofollow" target="_blank">https://datachant.com/2016/12/09/remove-empty-columns-rows-from-table-in-excel-power-query/</a> Favourite Articles: <a href="https://datachant.com/2019/10/17/bad-practices-power-bi-pie-charts/" rel="nofollow" target="_blank">https://datachant.com/2019/10/17/bad-practices-power-bi-pie-charts/</a> <a href="https://datachant.com/2017/01/06/10-mistakes-you-always-do-in-powerbi-powerquery/" rel="nofollow" target="_blank">https://datachant.com/2017/01/06/10-mistakes-you-always-do-in-powerbi-powerquery/</a>

The One with Gil Raviv

Mynda Treacy

"I can't think of anyone that uses Excel that wouldn't benefit from using Power Query" - Mynda Treacy How do you go from art studies in a beachside suburb school, to accountant at two London investment banks to a YouTube following of 326,000!?Mynda and I cover lots of ground in this conversation.  We have had similar journeys working overseas, working for banks, becoming accountants, getting hooked on Excel. Mynda has a huge following on YouTube and her online training business MyOnlineTrainingHub   I ask the longest and probably oddest  "Mpossible" question regarding the treatment of 01/01/1900 date.    We both learn a Power Query feature thanks to Miguel Escobar.Links: Power Query Automates Boring Tasks: https://youtu.be/L4BuUzccLpo Interactive Excel Dashboards with Power Query and Power Pivot: https://youtu.be/TK0CJBaqvnY

"I can't think of anyone that uses Excel that wouldn't benefit from using Power Query" - Mynda Treacy How do you go from art studies in a beachside suburb school, to accountant at two London investment banks to a YouTube following of 326,000!? Mynda and I cover lots of ground in this conversation.  We have had similar journeys working overseas, working for banks, becoming accountants, getting hooked on Excel. Mynda has a huge following on YouTube and her online training business <a href="https://www.myonlinetraininghub.com/" rel="nofollow" target="_blank">MyOnlineTrainingHub</a> I ask the longest and probably oddest  "Mpossible" question regarding the treatment of 01/01/1900 date.  We both learn a Power Query feature thanks to Miguel Escobar. Links: Power Query Automates Boring Tasks: <a href="https://youtu.be/L4BuUzccLpo" rel="nofollow" target="_blank">https://youtu.be/L4BuUzccLpo</a> Interactive Excel Dashboards with Power Query and Power Pivot: <a href="https://youtu.be/TK0CJBaqvnY" rel="nofollow" target="_blank">https://youtu.be/TK0CJBaqvnY</a>

The One with Mynda Treacy

Interviews with Power Query Magicians from around the worldAlso available on YouTube: https://www.youtube.com/channel/UCKeJBKP0-vXHFp7dwb9AW2Q

In this episode Lars introduces a brand new podcast feature - "my worst presentation ever!" We share our mutual nervousness of public speaking and discuss meetup groups and the MVP award. We get into the back story around his creation of the  Notepad++ Power Query Editor and reminisce about the last time we used VBA Enjoy: Check out the YouTube recording of this episode here https://youtu.be/KJlE3RFE7dQ   Links   Website:  https://ssbi-blog.de/category/blog/ Most Popular Posts :  Lists in PQ Power Query Editor using Notepad++ Favourite Post: The Enivronment ConceptRecommended Book:Profession Excel Development bookBrush with Fame...Braulio Estima

In this episode Lars introduces a brand new podcast feature - "my worst presentation ever!" We share our mutual nervousness of public speaking and discuss meetup groups and the MVP award. We get into the back story around his creation of the  Notepad++ Power Query Editor and reminisce about the last time we used VBA Enjoy: Check out the YouTube recording of this episode here <a href="https://youtu.be/KJlE3RFE7dQ" rel="nofollow" target="_blank">https://youtu.be/KJlE3RFE7dQ</a> Links <a href="https://ssbi-blog.de/category/blog/" rel="nofollow" target="_blank">Website:  https://ssbi-blog.de/category/blog/</a> Most Popular Posts : <a href="https://ssbi-blog.de/blog/technical-topics-english/lists-in-power-query-how-when-and-why/" rel="nofollow" target="_blank"> Lists in PQ</a> <a href="https://ssbi-blog.de/blog/technical-topics-english/power-query-editor-using-notepad/" rel="nofollow" target="_blank">Power Query Editor using Notepad++</a> Favourite Post: <a href="https://ssbi-blog.de/the-environment-concept-in-m-for-power-query-and-power-bi-desktop/" rel="nofollow" target="_blank">The Enivronment Concept</a> Recommended Book: <a href="https://www.amazon.de/Professional-Excel-Development-Applications-Addison-Wesley/dp/0321508793/ref=sr_1_1?__mk_de_DE=%C3%85M%C3%85%C5%BD%C3%95%C3%91&amp;dchild=1&amp;keywords=professional+excel+development&amp;qid=1622545276&amp;sr=8-1" rel="nofollow" target="_blank">Profession Excel Development book</a> Brush with Fame... <a href="https://www.bjjheroes.com/bjj-fighters/braulio-estima-facts-and-bio" rel="nofollow" target="_blank">Braulio Estima</a>

The One with Lars Schreiber

If you haven't seen Oz demonstrating Power Query via his Excel on Fire YouTube channel then you are missing out.  Our discussion takes us from good bars and good cookies to bad data, brave moves and a brush with fame I wasn't expecting Enjoy   Watch this episode on YouTube: https://youtu.be/zfuLTl8z4l8   Excel on Fire  https://www.youtube.com/channel/UCZgOVykPoRbSZQfY9YysiRQ Paqui One Chip Challenge: https://youtu.be/F9JsFnSx7dYXLOOKUP Summit: https://youtu.be/0KEhR66btUs Oz's Favourite: https://youtu.be/1dbXhynCqN8 Oz's Most Popular Video: https://youtu.be/v4taBhc9ENQOz's take on his most popular (regretted) blog post https://medium.com/@OzExcel/my-clickbait-worked-but-not-for-me-881ad386fcc

If you haven't seen Oz demonstrating Power Query via his Excel on Fire YouTube channel then you are missing out.  Our discussion takes us from good bars and good cookies to bad data, brave moves and a brush with fame I wasn't expecting Enjoy Watch this episode on YouTube: <a href="https://youtu.be/zfuLTl8z4l8" rel="nofollow" target="_blank">https://youtu.be/zfuLTl8z4l8</a> Excel on Fire  <a href="https://www.youtube.com/channel/UCZgOVykPoRbSZQfY9YysiRQ" rel="nofollow" target="_blank">https://www.youtube.com/channel/UCZgOVykPoRbSZQfY9YysiRQ</a> Paqui One Chip Challenge: <a href="https://youtu.be/F9JsFnSx7dY" rel="nofollow" target="_blank">https://youtu.be/F9JsFnSx7dY</a> XLOOKUP Summit: <a href="https://youtu.be/0KEhR66btUs" rel="nofollow" target="_blank">https://youtu.be/0KEhR66btUs</a> Oz's Favourite: <a href="https://youtu.be/1dbXhynCqN8" rel="nofollow" target="_blank">https://youtu.be/1dbXhynCqN8</a> Oz's Most Popular Video: <a href="https://youtu.be/v4taBhc9ENQ" rel="nofollow" target="_blank">https://youtu.be/v4taBhc9ENQ</a> Oz's take on his most popular (regretted) blog post <a href="https://medium.com/@OzExcel/my-clickbait-worked-but-not-for-me-881ad386fcc" rel="nofollow" target="_blank">https://medium.com/@OzExcel/my-clickbait-worked-but-not-for-me-881ad386fcc</a>

The One with Oz du Soleil

Chris Webb

Chris Webb is on the Microsoft Customer Advisory Team and a legend of the Power Query community. In this episode Chris discusses the moment he fell in love with Power Query and he has some advice for how to read M Code as we explore the journey of roles and experiences that led him to be where he is today.   Chris Webb's BI Blog Favourite Article Most Popular Article Video version on YouTube: https://youtu.be/cLxEYN5CSH8

Chris Webb is on the Microsoft Customer Advisory Team and a legend of the Power Query community. In this episode Chris discusses the moment he fell in love with Power Query and he has some advice for how to read M Code as we explore the journey of roles and experiences that led him to be where he is today. <a href="https://blog.crossjoin.co.uk/" rel="nofollow" target="_blank">Chris Webb's BI Blog</a> <a href="https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/" rel="nofollow" target="_blank">Favourite Article</a> <a href="https://blog.crossjoin.co.uk/2020/04/06/understanding-the-the-key-didnt-match-any-rows-in-the-table-error-in-power-query-in-power-bi-or-excel/" rel="nofollow" target="_blank">Most Popular Article</a> Video version on YouTube: <a href="https://youtu.be/cLxEYN5CSH8" rel="nofollow" target="_blank">https://youtu.be/cLxEYN5CSH8</a>

The One with Chris Webb

Ken Puls

Ken Puls is a Microsoft MVP of many years, co-author of THE original book on Power Query ( "M" is for Data Monkey) and well known personality of the Excel and Power Query World. Links discussed in this episode Excel Guru Newsletter https://www.excelguru.ca/content.php?335-Newsletter  SkillWave: https://skillwave.training/  MonkeyTools: https://www.excelguru.ca/content.php?341-Monkey-Tools  Vancouver User Group https://www.meetup.com/Vancouver-Power-BI-User-Group/  User Voice Table Name Prompt: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10580340-change-excel-table-name-in-the-create-table-window  Dataflows https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/36898132-add-power-bi-dataflows-as-a-data-source-in-get  Blog / Video / Article  Most Popular: https://www.excelguru.ca/blog/2014/08/27/the-if-function-in-power-query/  Favourite: Slowly Change Dimension Solution : https://youtu.be/Iq1D1VgAyeU  Monkey Tools Demo: https://youtu.be/FxwCtWN0uTs

Ken Puls is a Microsoft MVP of many years, co-author of THE original book on Power Query ( "M" is for Data Monkey) and well known personality of the Excel and Power Query World. Links discussed in this episode Excel Guru Newsletter <a href="https://www.excelguru.ca/content.php?335-Newsletter" rel="nofollow" target="_blank">https://www.excelguru.ca/content.php?335-Newsletter </a> SkillWave: <a href="https://skillwave.training/" rel="nofollow" target="_blank">https://skillwave.training/ </a> MonkeyTools: <a href="https://www.excelguru.ca/content.php?341-Monkey-Tools" rel="nofollow" target="_blank">https://www.excelguru.ca/content.php?341-Monkey-Tools </a> Vancouver User Group <a href="https://www.meetup.com/Vancouver-Power-BI-User-Group/" rel="nofollow" target="_blank">https://www.meetup.com/Vancouver-Power-BI-User-Group/ </a> User Voice Table Name Prompt: <a href="https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10580340-change-excel-table-name-in-the-create-table-window" rel="nofollow" target="_blank">https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10580340-change-excel-table-name-in-the-create-table-window </a> Dataflows <a href="https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/36898132-add-power-bi-dataflows-as-a-data-source-in-get" rel="nofollow" target="_blank">https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/36898132-add-power-bi-dataflows-as-a-data-source-in-get </a> Blog / Video / Article Most Popular: <a href="https://www.excelguru.ca/blog/2014/08/27/the-if-function-in-power-query/" rel="nofollow" target="_blank">https://www.excelguru.ca/blog/2014/08/27/the-if-function-in-power-query/ </a> Favourite: Slowly Change Dimension Solution : <a href="https://youtu.be/Iq1D1VgAyeU" rel="nofollow" target="_blank">https://youtu.be/Iq1D1VgAyeU </a> Monkey Tools Demo: <a href="https://youtu.be/FxwCtWN0uTs" rel="nofollow" target="_blank">https://youtu.be/FxwCtWN0uTs</a>

The One with Ken Puls

I'm Wyn Hopkins, Microsoft MVP, Power Query enthusiast, Excel and Power BI expert. On this channel I will be meeting with the people who are leaders in sharing their knowledge about Power Query. These are the people whose blogs, books, video and presentations I've been absorbing for many years. I'm excited to find out what makes them tick, how did they arrive at their current situation, and what advice and tips can they impart on us. I want this to be fun, and I want to raise the profile of Power Query by sharing stories from the array of M Code magicians out there. This is Power Query MagicCheck out our YouTube Channel: https://www.youtube.com/channel/UCKeJBKP0-vXHFp7dwb9AW2Q

I'm Wyn Hopkins, Microsoft MVP, Power Query enthusiast, Excel and Power BI expert. On this channel I will be meeting with the people who are leaders in sharing their knowledge about Power Query. These are the people whose blogs, books, video and presentations I've been absorbing for many years. I'm excited to find out what makes them tick, how did they arrive at their current situation, and what advice and tips can they impart on us. I want this to be fun, and I want to raise the profile of Power Query by sharing stories from the array of M Code magicians out there. This is Power Query Magic Check out our YouTube Channel: <a href="https://www.youtube.com/channel/UCKeJBKP0-vXHFp7dwb9AW2Q" rel="nofollow" target="_blank">https://www.youtube.com/channel/UCKeJBKP0-vXHFp7dwb9AW2Q</a>

The One with the Introduction

Interviews with Power Query Magicians from around the world Also available on YouTube: <a href="https://www.youtube.com/channel/UCKeJBKP0-vXHFp7dwb9AW2Q" rel="nofollow" target="_blank">https://www.youtube.com/channel/UCKeJBKP0-vXHFp7dwb9AW2Q</a>

Power Query Magic

The best podcast episodes on parenting. Interviewing experts and talking through common issues surrounding parenting. This topic is filled with important lessons and insights for anyone listening. Add episodes you're interested into your queue below!

OwlTail

Best Parenting Podcasts

The best podcast episodes on physical health. Episodes talk about your diet, sleep, exercise and all the things that people do to improve their physical health and live a healthier life. This topic is for everyone, with applications in all of our everyday lives. Add episodes you're interested into your queue below!