Excel table with the total line
If an Excel table has a total row, this table will be imported with the total row in Power BI as an ordinary row.
Adding this row will cause mistakes in the PBI report and I suppose that the majority of users don't need it in their models.
I suggest to ignore this row when we import an Excel table in Power BI and Power Query.
More explanation can be found in the link below: