Forum Discussion
Helper IImport from CSV gives error on Date conversion
Community ChampionBoth issues are related. If powerbi can't convert the field to date without throwing an error it can't recognise it as a legitimate date.
You will have to handle the conversion (either by splitting the field by delimiter - on space, or Text.Start() function or some other method) to get a format that will easily convert to date type.
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.