Forum Discussion
Solved
Slow CSV import
(I love it when signing up to post a message dumps the message I already typed up!) Hi everyone, I have an issue with importing CSVs very slowly. My workflow is this: 1. Process txt files...
Hi mwegener and v-easonf-msft,
It turns out that it was a rookie mistake. I was processing my data during the import process which was causing the import to be ridiculously slow. I've since imported the CSVs as is and am applying the calculations to the imported data, which has reduced the import process from 90 minutes to < 10 seconds!
Lesson learned, now just to figure out how to get my formulas to work again (since I now have combined data in one table instead of individual tables).
Thanks for the feedback, though!
yes...Detail please!