Notifications
Clear all
Topic starter
Hi,
I need to copy and paste tables loaded to data model to Excel. Can you tell me how I can do this?
Thanks.
Posted : 23/02/2024 9:29 am
Where does the data come from to begin with? If with Power Query, you can load it back to an Excel table AND the Data Model.
Posted : 23/02/2024 11:06 am
Use Riny's solution if your data was loaded via Power Query. If not, in the Power Pivot window, you can click the top left corner of the table where the row numbers and column names intersect to select the data, then CTRL+C to copy. Then paste where you want.
Posted : 23/02/2024 7:16 pm
Topic starter
Thanks! That works for me
Posted : 24/02/2024 11:15 am
FYI, you can also link the table in the data model to a table on a worksheet if you want, using the Existing Connections button on the Data tab. (You can actually create entire tables in DAX that way!)
Posted : 02/03/2024 1:30 pm