Microsoft Office Forums - View Single Post - Excel Power Query Not Returning All Rows

Thread: Excel Power Query Not Returning All Rows

View Single Post

Old

03-24-2022, 09:33 AM

rspiet

rspiet is offline

rspiet uses Windows 7 64bit

Windows 7 64bit rspiet uses Office 2010 32bit

rspiet uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Nov 2014

Posts: 12

rspiet is on a distinguished road

Default

Excel Power Query Not Returning All Rows

I am running an ODBC query to extract mainframe DB2 data. If I run the query on the mainframe, it extracts 290,055 rows. When I run it in Excel, it only returns 9,560 rows. There are no error messages. How do I get Excel to return all rows? Is there some parameter that I need to use?

Reply With Quote