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

[Liana_LPJFS]

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.

[amitchandak · Accepted solution]

@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