Forum Discussion

Leski's avatar
Leski
Frequent Visitor
6 years ago
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 ...
Need Help
  • Leski's avatar
    Leski
    6 years ago

    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. 

v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, Leski 

 

I'd like to suggest you specify the culture for Table.TransformColumnTypes  function.

Table.TransformColumnTypes(table as table, typeTransformations as list, optional culture as nullable text) as table

 

You may try to add 'en-US' for the third parameter of the function as below.

= Table.TransformColumnTypes(Source,{{"Test", type number}},"en-US")

 

About the culture for each region, you may refer to the link .

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.