Blank date is coming in Power Query

[aAmirkHan]

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 not a blank date in the date column.  

Can you please help me how to fix it?

[Omid_Motamedise · Accepted solution]

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]

[aAmirkHan]

Thank you @Omid_Motamedise 

The above step is working fine for me.

[lbendlin]

not there.  click on the settings icon next to the "Source" step.  

[aAmirkHan]

Thank you @lbendlin for the response.

I am still unsure and seeking your advice. Please let me know what option I should choose while importing CSV file data in Power Query. Please refer to the screenshot below.

 

[lbendlin]

change your CSV ingestion to "ignore quoted line breaks"  and make sure you use the correct encoding.