Episodes
Saturday Dec 10, 2022
The One with Miguel Escobar
Saturday Dec 10, 2022
Saturday Dec 10, 2022
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 Training
Now a Product Manager at Microsoft working on Power Query - Miguel is someone who wants to help everyone turn their data into useful information
Check out www.powerquery.com
Also a musician with his song Someday Somehow available to listen to
Spotify – Someday, Somehow
Someday, Somehow (feat. Chris Cron) - Single by PAB on Apple Music
Monday Dec 05, 2022
The One with Matt Allington
Monday Dec 05, 2022
Monday Dec 05, 2022
****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
Monday Dec 05, 2022
The One with Erik Svensen
Monday Dec 05, 2022
Monday Dec 05, 2022
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
Sunday Oct 02, 2022
The One with Rick de Groot
Sunday Oct 02, 2022
Sunday Oct 02, 2022
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
Sunday Jun 12, 2022
The One with Celia Alves
Sunday Jun 12, 2022
Sunday Jun 12, 2022
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://solveandexcel.ca/2020/09/11/enable-background-refresh-property-in-power-query-in-excel/
And her most popular here
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_excel
The Dataflow Connector code I mention briefly is = PowerPlatform.Dataflows(null)
Sunday May 29, 2022
The One with Chandeep Chhabra
Sunday May 29, 2022
Sunday May 29, 2022
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 Bar
The 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
Sunday May 15, 2022
The One with Ed Hansberry
Sunday May 15, 2022
Sunday May 15, 2022
"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
Sunday May 01, 2022
The One with Miguel Llopis
Sunday May 01, 2022
Sunday May 01, 2022
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
Saturday Sep 04, 2021
The One with Imke Feldmann
Saturday Sep 04, 2021
Saturday Sep 04, 2021
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
Saturday Aug 21, 2021
The One with Alex Powers
Saturday Aug 21, 2021
Saturday Aug 21, 2021
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