copy a table into new file

Question

I am trying to copy data from a table I created appending 254 separate tables into one.&nbsp; (The data in the appended table comprises over 25 million rows and 26 columns.) &nbsp; I want to copy the appended table into a new file and save it separately, so that the new table does not rely on the 254 tables used to append it.&nbsp; I cannot figure out how to do this.&nbsp; I have tried "copy" "copy table", etc.&nbsp; Is this possible?&nbsp; If so, how?&nbsp; Thank you. &nbsp;

anonymous · Answer

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.&nbsp; Choose the option "Copy Table", which will attempt to copy the data into your clipboard.&nbsp; From here, paste the data into Excel.&nbsp; You can use this Excel table as your data source for a new file.

awillem · Answer

I don't believe Excel will support more than one million rows.&nbsp; The data I am using has 25 million rows. &nbsp;

Forum Discussion

copy a table into new file

2 Replies

Related content

Upsert data to Lakehouse Table using copy data

Copy Job vs Copy Activity

Copy paths

Copy Job OVERWRITE

Copy Data show Null on Table