Import Excel Sheet - "This table is empty"

[LeeSherlock]

Hello Power Bi community.

I have a really strange behaviour while trying to import a sheet from an Excel file.

The sheet definately has data in it

Now when I'm importing this in Excel, it reads the headers but otherwise tells me that the sheet is empty:

The sheet its self is automatically downloaded on a daily basis

Can anyone help?

[lbendlin]

You connected to a table, not a sheet.  Change your connection to point to the sheet instead.