Forum Discussion

elokapo's avatar
elokapo
Frequent Visitor
3 years ago

Format number not recognized

Hi, When trying to load an excel file with a column (Fee) having numbers, POwerBI Query does not recognize it as Decimal Number. It gives for example 123.123.125.12 while I am expecting 123123125.1...
Need Help
Tips and Tricks
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
3 years ago

elokapo 

 

If PQ is doing an automated Change Type step on that coumn, delete it and try manually converting using Change Type using Locale

 

 

 

Looks like you are using a German (Swiss) format?

 

Regards

 

Phil

 

  • elokapo's avatar
    elokapo
    Frequent Visitor
    3 years ago

    Hi,

    I take those xls files from a folder. Those are the steps I have : (I have no Change Type)

     

     

    The data comes directly like that:

     

     

    Thx,

    E.

     

     

    • elokapo's avatar
      elokapo
      Frequent Visitor
      3 years ago

      Here is what I have when loading the files: