missing data with xls file

Hi,

Thank you for your answer, unfortunetely our datas are confidentials, but i give you more details:

As I Said above I have some differencies when I import an Excel file with the extension .xls or .xlsx.

When I use .xlsx all is perfect. I have all the data when I put them in a table vizualisation.

Point is, when I do this with .xls file, Some of the datas are missing. This is the two first columns which are missing. Maybe because the first cells of those columns are empty. But Why ?

And then, when I put  .xls data in table vizualisation, it automatically add me a row at the end with the sum of the columns with numbers

I use 32 bits excel and 64 bits  Power BI.

I want the exact  result with  .xlsx or .xls file. I don't know how to fix it .

Kind regards

Chantal