Forum Discussion

Liana_LPJFS's avatar
Liana_LPJFS
New Member
4 years ago
Solved

Copy 10,00+ rows from Power Query in Power BI

I need to copy all rows (10,000+) from Power Query and paste into Excell. I need the format as in Power Query. Copy entire table gives only 1,000 rows, eve

 

Please advise.

  • Liana_LPJFS , You can copy paste from data view easily , you have scroll unless you get all 100K records to get that

     

    refer all options here - https://youtu.be/1_XlyzV-PcY

     

    Check you make column profile on all columns does it make any diff, option status bar of power query

     

     

1 Reply

  • Liana_LPJFS , You can copy paste from data view easily , you have scroll unless you get all 100K records to get that

     

    refer all options here - https://youtu.be/1_XlyzV-PcY

     

    Check you make column profile on all columns does it make any diff, option status bar of power query