Forum Discussion

LanaPow's avatar
LanaPow
Regular Visitor
6 years ago
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...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi LanaPow 

    lets check

    add index column in power query mode, then create a card visual and set MAX of this index as value

    do not hesitate to give a kudo to useful posts and mark solutions as solution

  • LanaPow's avatar
    LanaPow
    6 years ago

    Hi Az, thank you.   I did that. The Max of the index is the number of rows in the table. What next? 

az38's avatar
az38
Community Champion
6 years ago

Hi LanaPow 

lets check

add index column in power query mode, then create a card visual and set MAX of this index as value

do not hesitate to give a kudo to useful posts and mark solutions as solution

phaering's avatar
phaering
Helper I
5 years ago

I have this same question.  I have tried following along with our solution and I created the visual card.  When I export the data off the visual card I only get two cells of data and not the 75K rows and 40 columns of data I need to see in a worksheet in Excel.  Did I miss a step or what am I not doing that will allow me to export all the data from the table and not just the first 1K rows?  Thank you!