Forum

Copy table in data ...
 
Notifications
Clear all

Copy table in data model to excel

5 Posts
4 Users
0 Reactions
102 Views
(@yyou)
Posts: 2
New Member
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
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

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
(@mynda)
Posts: 4761
Member Admin
 

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
(@yyou)
Posts: 2
New Member
Topic starter
 

Thanks! That works for me Smile

 
Posted : 24/02/2024 11:15 am
(@debaser)
Posts: 837
Member Moderator
 

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
Share: