I Let AI Clean My Messy Data, Here’s What Happened @GoodlyChandeep
I Let AI Clean My Messy Data, Here’s What Happened  @GoodlyChandeep
Uploaded August 2026 | Updated September 2026, 3 weeks ago
Download the Practice File ⬇️ - goodly-3z90kg.subscribepage.io
youtu.be/R5fN5s5DyOM?si=9wVXbE_M7WlQ8PpW


I gave Claude a folder containing messy LinkedIn post data and asked it to clean and combine everything inside Power BI.

With only two vague prompts, Claude created a working Power Query solution in less than an hour. The output looked correct at first, but the real test began when I checked the code behind it.

The query contained a hard-coded folder path, fixed column names, unnecessary steps, and a date conversion that quietly produced the wrong result. The model still refreshed, so the mistake could easily go unnoticed.

In this video, I review the complete solution, explain what Claude did well, show where the logic can fail, and rebuild the query using a shorter and more reliable approach.


===== 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 File ⬇️ - goodly-3z90kg.subscribepage.io


===== CHAPTERS =====
0:00 - Intro
1:04 - Chapter 1
4:34 - Chapter 2
5:43 - Chapter 3
15:23 - Chapter 4


===== 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!
I Let AI Clean My Messy Data, Here’s What Happened3 Excel Shortcuts That Save Me Every DayI Didn’t Expect AI to Do This in Power QueryApproximate Searches using XLOOKUPThe Fastest Way to Sort in ExcelCombine Data from Multiple Sheets into a Single Excel File | Most Dynamic Method🔴 The Framework for Solving Advanced Data Cleaning Problems | Live EventUseful Power BI tip to Keep the Model Fast ⚡Don’t Learn Everything. Learn What Matters.XLOOKUP in Power BI?Stack Multiple Columns into One in Power Query 💡Super Useful Inclusion & Exclusion Functions in DAX #powerbi #dax
Goodly |

I Let AI Clean My Messy Data, Here’s What Happened

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER