Forum Discussion
Solved
Blank date is coming in Power Query
Hi, I am importing a CSV file containing more than 700K in Power Query. However, I am also getting null in my date column in PQ. Although I have checked the date in my source CSV file, there is...
In the step of extracting data from csv rewrite the formula as bellow
Text.Csv(
File.Contents("C:\YourFilePath"),
[Delimiter=",", Columns=8, Encoding=65001, QuoteStyle=QuoteStyle.Csv]
In the step of extracting data from csv rewrite the formula as bellow
Text.Csv(
File.Contents("C:\YourFilePath"),
[Delimiter=",", Columns=8, Encoding=65001, QuoteStyle=QuoteStyle.Csv]
Thank you Omid_Motamedise
The above step is working fine for me.
