Miguel Escobar is the co-author of the original book on Power Query - "M" is for data monkey and its recent completely re-written version "Master Your Data"Master Your Data with Excel and Power BI - Skillwave TrainingNow a Product Manager at Microsoft working on Power Query - Miguel is someone who wants to help everyone turn their data into useful informationCheck out www.powerquery.com Also a musician with his song Someday Somehow available to listen toSpotify – Someday, Somehow‎Someday, Somehow (feat. Chris Cron) - Single by PAB on Apple Music

****Blatant Advert****Did you know I've written a book "Power BI for the Excel Analyst" - https://pbi.guide/********************Author of Supercharge DAX, trainer, speaker and all-round good guy, Matt is a Sydney based pillar of the Power Pivot / Power BI community.Any greater achievement than coining the phrase "The Collie Method?"Check out Matt's favourite Power Query article: https://exceleratorbi.com.au/build-reusable-calendar-table-power-query/Most popular: https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/VOTE FOR THIS:Remove Camel Case https://ideas.powerbi.com/ideas/idea/?ideaid=ed3364a1-fa9b-ec11-826d-281878de31cb Check out https://www.youtube.com/@PowerQuery

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 anotherHow to handle different decimal separators LinkedIn: https://www.linkedin.com/in/eriksvensen/Twitter: https://twitter.com/donsvensen

Accountant turned consultant, Rick is a newly minted MVP with a lot of thoughtful and insightful comments around Power Query and working in the data world. He sets a new record for the Just A "M"inute game!YouTube version: https://youtu.be/3IPFdtFi_UI   Check out Rick's links Favourite Post https://gorilla.bi/power-query/list-functions/ Most popular https://gorilla.bi/dax/5-ways-to-calculate-last-12-months-in-dax/ And good news... Query collections are coming... https://learn.microsoft.com/en-us/power-platform-release-plan/2022wave2/data-integration/save-curate-personal-query-collection-power-query LinkedIn: https://www.linkedin.com/in/rickmaurinus/ Twitter: https://twitter.com/Rickmaurinus

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)

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

"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

Talking Power Query with Miguel Llopis Group Product Manager, Citizen Data Integration @ Microsoft

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 & let | Ben Gribaudo

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