Forum Discussion
Solved
Import from CSV Decimal separator - changes to date
Hello I have a problem with import from CSV. The decimal separator is a dot, but the import PQ will change some values to date. For exaple 11.44 is paź.44 (short month name and short year). I know ...
I found an error in the csv file. All you had to do was open csv in excel and save, then csv converted some numbers into text "paź.44". Unfortunately . It is not conected with Power BI and regional setings.
Thank you all for your advice and help, it will help in the future.
I found an error in the csv file. All you had to do was open csv in excel and save, then csv converted some numbers into text "paź.44". Unfortunately . It is not conected with Power BI and regional setings.
Thank you all for your advice and help, it will help in the future.