The Power Query Magic YouTube version is available here... https://youtu.be/07zOX5IYImI

Gil is author of the excellent book Collect, Combine, and Transform Data Using Power Query in Excel and Power BI https://datachant.com/next/

We discuss Gil's experience as one of the Program Managers on the Excel team where he was closely involved with Power Query in it's earliest days.

We discover one of Gil's first ever blog posts was the inspiration for my first ever YouTube video

Gil's post: https://p3adaptive.com/2015/05/harness-power-query-to-gain-competitive-analysis-insights-from-linkedin/

My Video: https://youtu.be/uej_Uc3__bE

Links:

Gil's App Source Apps: https://appsource.microsoft.com/en-us/marketplace/apps?page=1&search=datachant

Most Popular Article

https://datachant.com/2016/12/09/remove-empty-columns-rows-from-table-in-excel-power-query/

Favourite Articles:

https://datachant.com/2019/10/17/bad-practices-power-bi-pie-charts/

https://datachant.com/2017/01/06/10-mistakes-you-always-do-in-powerbi-powerquery/