Forum Discussion
elimey
Helper I
Helper IImport from CSV gives error on Date conversion
I am trying to import a csv file, I have two issues: - first, all the columns are being imported as Text. Even with "Always detec data type" option on, everything is imported as text. What can I do?...
elimeyHelper I
Helper Iwhen I open the csv as Excel, and load it to PowerBI, it works perfectly. But, when with CSV, it won't work.
I am trying to find a best solution, cause I have many columns in the CSV and I can't do manual conversion for all of them.
Is ther eany other solution?
My suggestion is so you can find the row(s) giving you the error. This will help determine what is causing the problem. Excel might have so intelligence to handle the issue that Power Query does not have.