Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Decimal loss when loading from .xls file

Hi all, Question Using the folder import I am loading several .xls files of the same format. This all works well (aside from the fact that I have to open and save all .xls files separately withou...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    Try to avoid using .XLS files. If possible, use .XLSX or equivalent.

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi all,

     

    Solved it by converting all files to .xlsx using an internet/cloud based solution, very simple and not costly. I did it this way because .xls is an old format that doesn't carry meta data very well, and I couldn't get the .xls file showing the deciamal files correctly.  

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Try to avoid using .XLS files. If possible, use .XLSX or equivalent.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Ibendlin,

     

    Thankyou for your reply. Converting all files to .XLSX does seem to solve the issue. For other people with this question: this can be done easily and secured using online converter tools at little cost. 

     

    One question regarding your answer: why is .XLSX better than .XLS? I encounter .XLS files quite often so I thought it ought to be supported by Power BI right?

    Thanks!

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      It's an ancient format that does not carry meta data well. It is not supported on the gateway or the Power BI service.