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? 

LanaPow's avatar
LanaPow
Regular Visitor
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? 

LanaPow's avatar
LanaPow
Regular Visitor
6 years ago

Hi az38 

ok i've explored around a bit, and i found that i can export the data from this visual into a file ))))

it's really cool how you answered, made me do some foot work but also helped ))

Thank you!