Forum Discussion

bdenny's avatar
bdenny
Frequent Visitor
9 years ago
Solved

Cannot transform text to decimal after Combing Binaries

Hi,

 

I have a folder with a lot of csv-files and they have the same columns. When I tell Power BI to combine all those csv-files using 'Combine Binaries it looks pretty good but each column has the data type 'text'. So I can't create any visualizations yet because the column containing values is still seen as text and when I try to transform it to decimal is shows an Error. When I filter that specific column the values look very weird:

 

 

Any idea why Power BI reads the data this way? A sample of the raw data for this column:

28

1.238

42.890

Need Help
  • bdenny's avatar
    bdenny
    9 years ago

    Hi,

     

    Thanks for your reply. The / you saw is a 7. But Power BI detected the wrong encoding. When I selected the right encoding (Unicode) everything works fine :-)

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi bdenny,


    According to your screenshot, I find a lot of types in your column.(text: 1.1/1, decimal number, whole number)

    Since your column contain the data which can't convert to decimal(1.1/1), it may get some odd result when you try to convert them.

     

    In addition, can you share us a sample file to test?

     

    Regards,

    Xiaoxin Sheng

    • bdenny's avatar
      bdenny
      Frequent Visitor
      9 years ago

      Hi,

       

      Thanks for your reply. The / you saw is a 7. But Power BI detected the wrong encoding. When I selected the right encoding (Unicode) everything works fine :-)