Forum Discussion
copy a table into new file
I am trying to copy data from a table I created appending 254 separate tables into one. (The data in the appended table comprises over 25 million rows and 26 columns.) I want to copy the appended ...
Assuming this is a once off step you only want to do once, I would go into the Data View of your Power BI Desktop, find your table in the Field Selector and right-click on its name. Choose the option "Copy Table", which will attempt to copy the data into your clipboard. From here, paste the data into Excel. You can use this Excel table as your data source for a new file.
I don't believe Excel will support more than one million rows. The data I am using has 25 million rows.