Error We couldn t find any data in your Excel workbook

Question

I was importing an Excel workbook into Power BI, then facing the mentioned error above. Can someone suggest what to do to resolve this issue?

Answer 1

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

1. Edit your workbook in Excel.
2. Select the range of cells that contain your data. The first row should contain your column headers (the column names).
3. Press Ctrl + T to create a table.
4. Save your workbook.
5. 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.