Power Query Magic Wyn Hopkins
-
- Technologie
-
Meet the Power Query Magicians from around the world
-
The One with Miguel Escobar
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, SomehowSomeday, Somehow (feat. Chris Cron) - Single by PAB on Apple Music -
The One with Matt Allington
****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 -
The One with Erik Svensen
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
-
The One with Rick de Groot
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 -
The One with Celia Alves
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)
-
The One with Chandeep Chhabra
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