Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply

Table is empty message

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.

 

dapperscavenger_0-1699973992941.png

 

 

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

 

1 ACCEPTED SOLUTION
AnalyticPulse
Super User
Super User

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.

View solution in original post

3 REPLIES 3
AnalyticPulse
Super User
Super User

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.

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
Not applicable

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

 

--Nate

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.