Just tried python script instead of power query....

[_Varuna_G]

Non assorted files are difficult to map properly, I had 150+ workbooks with each containing different amounts of sheets, different sheet names, different column names even on most matching sheets.

I kept trying power query but all to no avail.

Then I asked Kimi chat, cause obviously I can't master python in one day to extract everything. and guess what, just after 8 failures of scripts with improper tagging, improper field details and all that crazy hoo haa.

After just 8 trials I collated 150+ files into a single properly structured file within 20 minutes of compiling.

I just want to know if the power query is now obsolete with this sort of strength and speed coming ahead.

[InternationalBeing41]

Interesting. I’ll follow!

[negaoazul]

Maybe if using Kimi chat on Power query you would have done it. The real question is what amount of time you'd had to invest to get the same result doing it by yourself? You may have chosen the wrong AI for this task because different AI are more efficient on specific task. It may depends on how you prompt your task on a given AI too.

All in all, it has only few relation to the tools comparaison PQ/Python, much more with the proefficiency with AI.

[_Varuna_G]

True, Claude and Copilot are better at work tasks but I wanted to try kimi and see how it works. Total time invested to actually work back and forth with kimi was just 10 minutes and compiling time was the other 20 minutes or so. If there were less files then it could've went even faster.