Forum Discussion
Power Query Only Importing 14,568 Lines of 15,500 into Excel
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...
I'm going to take a guess here because I've seen this a few times and the solution might be very easy.
It's possible PowerQuery is reading the dimensions of the sheet from the sheet's XML (Which might not encompass all rows). A way to reset it, open that workbook, save it, close it, and then try to query it again.
It's possible PowerQuery is reading the dimensions of the sheet from the sheet's XML (Which might not encompass all rows). A way to reset it, open that workbook, save it, close it, and then try to query it again.