Uploaded January 2026 | Updated September 2026, 3 weeks ago
Download the Practice Kit ⬇️ - goodly.co.in/i-competed-with-ai-and-lost
Join my Power BI Community - products.goodly.co.in/learn-dax-powerbi#:~:text=Start%20Your%20Learning%20Journey!
In this video, I take a real Power Query data cleaning problem and try to solve it using AI. The idea is simple. Can AI handle the problem the same way a human would, and where does it start to struggle?
I break the solution into three parts. First, I use a very basic AI prompt and show why the result works but doesn’t scale. Then I improve the prompt and test a more flexible AI-generated solution, while pointing out some hidden issues that can appear with larger data.
Finally, I walk through my own Power Query approach and explain the thinking behind it. The focus is on building scalable logic, reducing hard-coding, and understanding how data is structured before writing M code.
This video is useful if you use AI with Power Query and want to understand when to trust it and when to rely on your own data thinking. I’ve also shared the full solution and AI prompts as a downloadable file linked below.
youtu.be/qlbU3jUsQAs?si=D_8JPi4bs3DbK3hj
===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book
✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?
✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi
✔️ Power Query Course -
products.goodly.co.in/learn-power-query
✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel
===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting
Download the Practice Kit ⬇️ - goodly.co.in/i-competed-with-ai-and-lost
===== CHAPTERS =====
0:00 - Intro
0:59 - Stage 1
3:59 - Stage 2
6:55 - Stage 3
===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
Download the Practice Kit ⬇️ - goodly.co.in/i-competed-with-ai-and-lost
Join my Power BI Community - products.goodly.co.in/learn-dax-powerbi#:~:text=Start%20Your%20Learning%20Journey!
In this video, I take a real Power Query data cleaning problem and try to solve it using AI. The idea is simple. Can AI handle the problem the same way a human would, and where does it start to struggle?
I break the solution into three parts. First, I use a very basic AI prompt and show why the result works but doesn’t scale. Then I improve the prompt and test a more flexible AI-generated solution, while pointing out some hidden issues that can appear with larger data.
Finally, I walk through my own Power Query approach and explain the thinking behind it. The focus is on building scalable logic, reducing hard-coding, and understanding how data is structured before writing M code.
This video is useful if you use AI with Power Query and want to understand when to trust it and when to rely on your own data thinking. I’ve also shared the full solution and AI prompts as a downloadable file linked below.
youtu.be/qlbU3jUsQAs?si=D_8JPi4bs3DbK3hj
===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book
✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?
✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi
✔️ Power Query Course -
products.goodly.co.in/learn-power-query
✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel
===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting
Download the Practice Kit ⬇️ - goodly.co.in/i-competed-with-ai-and-lost
===== CHAPTERS =====
0:00 - Intro
0:59 - Stage 1
3:59 - Stage 2
6:55 - Stage 3
===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
