Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
hey, when i try to import data from a file with text and numbers - the power query changes the text into numbers and i dont know why... i hope you can help me with this .....
the NQ text changes into numbers in the diagram and also if i execute it - in the power query it will be numbers and not the text (NQ). have nice sunday!
hey, thank for helping. the m-code:= Csv.Document(File.Contents("C:\chetrem\Short 1\User_Files\BackTesting_Read_files\ReadDataF3.txt"),[Delimiter=",", Columns=8, Encoding=1255, QuoteStyle=QuoteStyle.None])
it suppose to be for like 25 miliion row if thats matter
here is a few lines from the data:
NQ,09/01/2021 16:00:00,0,0,15634,15634.25,69935,15634.25
NQ,09/01/2021 16:00:01,0,0,15633.75,15634.25,69937,15633.75
NQ,09/01/2021 16:00:02,0,0,15633.5,15634,69946,15633.5
NQ,09/01/2021 16:00:03,0,0,15633.5,15633.75,69955,15633.5
NQ,09/01/2021 16:00:04,0,0,15633.5,15633.75,69957,15633.5
NQ,09/01/2021 16:00:05,0,0,15633,15633.5,69963,15633.5
NQ,09/01/2021 16:00:06,0,0,15632.75,15633.25,69970,15632.75
NQ,09/01/2021 16:00:07,0,0,15632.75,15633.25,69971,15632.75
NQ,09/01/2021 16:00:08,0,0,15632.75,15633.25,69971,15632.75
NQ,09/01/2021 16:00:09,0,0,15632,15632.5,69974,15632
NQ,09/01/2021 16:00:10,0,0,15632.25,15632.75,69978,15632.75
NQ,09/01/2021 16:00:11,0,0,15632,15632.5,69982,15632
NQ,09/01/2021 16:00:12,0,0,15632,15632.5,69982,15632
Still cannot reproduce the problem.
Perhaps, since the file seems to be English and not Hebrew, changing the encoding to 1252 might help.
But I doubt it, since the first two characters are `NQ` for each line (and not some unusual unicode equivalent), and I don't see how, after just the line of code you posted, they would change to different numeric values.
Hopefully someone else will come along with an idea.
I cannot reproduce your problem
Please copy/paste some data from the text file you are importing (text, not a screenshot), as well as the M-Code text from the Advanced Editor in Power Query.
It doesn't make sense to me that `NQ` would get converted into integers, especially different integers.