To import from Excel into the Power BI service, you need to format the data as a table. Select all the data you want in the table and press Ctrl+T.
Another Quick solution
- Edit your workbook in Excel.
- Select the range of cells that contain your data. The first row should contain your column headers (the column names).
- Press Ctrl + T to create a table.
- Save your workbook.
- Return to Power BI and import your workbook again, or if you're working in Excel 2016 and you've saved your workbook to OneDrive for Business, in Excel, click File > Publish.