The One with 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