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

  • 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? 

    • az38's avatar
      az38
      Community Champion
      6 years ago

      LanaPow 

      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

      • LanaPow's avatar
        LanaPow
        Regular Visitor
        6 years ago

        az38   thank you! 🙂

         

    • 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!

  • 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!