Forum Discussion
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 not a blank date in the date column.
Can you please help me how to fix it?
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]
5 Replies
not there. click on the settings icon next to the "Source" step.
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.
change your CSV ingestion to "ignore quoted line breaks" and make sure you use the correct encoding.
