Forum Discussion
Solved
Power Query, Copy Entire Table only copes 1000 rows
Power BI Desktop, office 365. 32bit, Win 10. I have 25k rows table that i need to check in Excel using Copy Entire Table option only copies 1000 rows, unless I scroll down. Which is hardly "entire...
Hi Az, thank you. I did that. The Max of the index is the number of rows in the table. What next?
Hi Az, thank you. I did that. The Max of the index is the number of rows in the table. What next?
only 1000 rows is not an error.
there are two mode of data view:
power query (power editor) is the only PREVIEW of data. it helps you to understand what data modification you need to do for your business logic achievement
in the normal mode (where you are seeing the correct max value) each of your rows (more then 1000) participatec in your calculation
dont worry, calculations are gonna be good, even if in power editor mode dont see all your data
do not hesitate to give a kudo to useful posts and mark solutions as solution