The One with Ken Puls

Power Query Magic

May 17, 2021•54 min•Season 1Ep. 2

--:--

Listen in podcast apps:

Apple Podcasts

Spotify

Download

Listen to this episode in Metacast mobile app

Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more

Episode description

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

Favourite: Slowly Change Dimension Solution : https://youtu.be/Iq1D1VgAyeU

Monkey Tools Demo: https://youtu.be/FxwCtWN0uTs

For the best experience, listen in Metacast app for iOS or Android