Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
Proud to be a Super User!
In the home Tab goto advanced Editor and share the snap of it . can help you with that!
Proud to be a Super User!
hI sIR
tHANK YOU FOR YOUR HELP , below is the screen shot.
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
Proud to be a Super User!
Hi Sir
now it got anotherr error
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
74 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |