Forum Discussion
Power Query is not combining csv rows properly
I have about 40 csv files each with 2000 rows. After using Power Query to combine the 40 files from folder, I get 332 errors. When I investigate the errors I see the data has not imported proper...
Hello Herc,
The snaphots are really helpful. Could you please share the sample data, so it will be easy to find the solution?
Sharing the pbix file is super recommended.
Hi Jayaselvan. Thank you for your reply.
When combining them in Power Query this is what happens.
How do I include the sample files? I don't have a pbix file just yet because I need to figure out how to combine this data first.