Forum Discussion
Large CSV Files
amitchandak , it's always just the comma. I'm wondering if it's the file itself the problem, CSVs should be always smaller right? but when I convert it in xlsx the file size gets smaller.
Anonymous the problem in the misalignment is just certain count of rows not just one file is getting misaligned. Which I really find weird. I also tried using the Date Locale but it still doesn't work, what worked is that I converted the column to Text first then added a column to convert text to DateTime. I think the problem stems out really in the file itself which I don't know what it is.
Anonymous , I doubt file size can be an issue. CSV in uncompressed and excel is. So if you convert this CSV to excel and do not give an issue then it is a problem to solve. else it is a data issue.
amitchandak the real data source is from CSV. I just tested to convert it into XLSX and weirdly enough it didn't have any error.
Anonymous , I think then it just the format issue. Check which format did excel taken it might not UTF-8 or something you are selecting. Just try to get that and choose that file loading in power bi
There is an option while loading: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-csv
Also, see if this can help
Hi , Anonymous
Do you have resolved it? If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.
Best Regards,
Community Support Team _ Eason
