Try import CSV raw data with only Date field stuck at power quary

[Paulyeo11]

Hi All

I have below excel CSV raw data :-

When import the above CSV file to PBI , i get stuck as below screen.

Hope some one advise me.

Paul Yeo

[VijayP]

@Paulyeo11 

In the home Tab goto advanced Editor and share the snap of it . can help you with that!

[Paulyeo11]

hI sIR

tHANK YOU FOR YOUR HELP , below is the screen shot.

[VijayP · Accepted solution]

@Paulyeo11 

In the advanced Editor Paste this code after removing the previous Code

Please take care of File Location and Header Name (Bold and underline content) and it should work for you

Please share your Kudoes

let
Source = Csv.Document(File.Contents("C:\users\lenovo\desktop\csv test.csv")),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
Custom1 = Table.TransformColumnTypes( #"Promoted Headers",{{"AR Invoice Date",type date}})
in
Custom1

[Paulyeo11]

Hi Sir

now it got anotherr error 

[VijayP]

@Paulyeo11  

I understood the problem it is because of your Regional settings you are using D/m/yy and the dates are in different format

let
Source = Csv.Document(File.Contents("File Location"),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"AR Invoice Date", type any}}),
#"Changed Type with Locale" = Table.TransformColumnTypes(#"Changed Type", {{"AR Invoice Date", type date}}, "en-IN")
in
#"Changed Type with Locale"

use this Code