Feb 16 2023 05:13 AM
I have exported 15,500 lines of data (with 28 columns) using Delimiter: Tab from MicroStrategy 2020 to a text file.
I have verified there are 15,500 lines in the text file.
When I import into Excel Power Query in the Power Query Editor window only 14,568 lines appear. (This is at the very first step Source before any steps have been added.)
How can I get up to 50,000 lines to import or is this a limitation of Power Query or Excel?
I am using Excel from within Microsoft Office Professional Plus 2016.
Excel 2016 (16.0.5378.1000) MSO (16.0.5366.1000) 32-bit
Feb 16 2023 11:32 AM
Feb 23 2023 06:26 AM
I identified the problem. PQ was importing data from the original file. I had failed to change the SOURCE in PQ when I changed the source file location. Thank you to everyone who responded.