Table is empty message

[dapperscavenger]

Hi

I'm bringing in an excel file (which definitely has many rows of data!) but when I try to bring it into powerquery I see the below.  No rows of data visible, ony the headers.

The report works for other files I bring in, just not this one.  Any thoughts?

[AnalyticPulse · Accepted solution]

maybe that excel is corrupted or incompatible, can you check the version or click on refresh button above. try to save another copy of excel, save it by another name and then import. check the file format.

[dapperscavenger]

Yes, okay, not sure exactly what the issue was, as the excel seemed to work fine.  But I threw it into a blank workbook, saved with same filenmame, and now the powerquery picks it up no issues.

[Anonymous]

Can you make the data on the worksheet a proper table, and then try again?

--Nate