|
|
#1
03-24-2022, 09:33 AM
|
|||
|
|||
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? 
|
| Tags |
| db2, power query |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel power query help | ganesang | Excel Programming | 0 | 09-20-2021 01:50 AM |
| Issue with Power Query editor/Data model-Excel 2016 | Meg Mika | Excel | 0 | 11-12-2019 01:05 PM |
| Do I need a power query for this one? | shabbaranks | Excel | 5 | 04-10-2019 03:29 AM |
| Issues Using Power Query file in Excel 2016 and then in 2013 | bld9936 | Excel Programming | 0 | 02-27-2017 12:50 PM |
| Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode