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
rmcgrath
Advocate II
Advocate II

Table rows not being pulled in?

I recently encountered my Power BI Report (in Desktop) not pull in all the rows of an Excel table.  I have the table named and sized correctly so I cannot figure out why it is excluding some rows?  I even checked the data types of the missing rows and could not find any that were different from rows that do get pulled in.

 

Thoughts on this?

1 ACCEPTED SOLUTION
Khushidesai0109
Super User
Super User

Hii @rmcgrath 

1. Check if "Remove Errors" or "Remove Rows" Steps Exist in Power Query.

2. Ensure the Excel Table is Fully Selected.

3. Check for Data Type Mismatches.

4. Try Importing Data in a New Query.

5. Check Power BI's "Load More" Option for Columns with Mixed Data.

6. Try Refreshing with "Clear Cache".

 

If this helps, I would appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!

 

Proud to be a Super User!!

View solution in original post

2 REPLIES 2
Khushidesai0109
Super User
Super User

Hii @rmcgrath 

1. Check if "Remove Errors" or "Remove Rows" Steps Exist in Power Query.

2. Ensure the Excel Table is Fully Selected.

3. Check for Data Type Mismatches.

4. Try Importing Data in a New Query.

5. Check Power BI's "Load More" Option for Columns with Mixed Data.

6. Try Refreshing with "Clear Cache".

 

If this helps, I would appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!

 

Proud to be a Super User!!
SamanthaPuaXY
Helper II
Helper II

Hi @rmcgrath ,

 

That's unlikely to happen. Perhaps you could check if you are pulling the right excel table? Or are you pulling the excel worksheet instead?

 

Otherwise would be worth clearing cache and see if it helps the situation. Do give a kudos if this helps!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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