Forum Discussion
Liana_LPJFS
4 years agoNew Member
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
- amitchandak
Super User
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