There's not really a copy and paste button in Power BI. However, the TMDL view comes very close!
The problem:
How to copy and paste a table in Power BI? Even though you can copy and paste the Power Query tables, all other data properties need to be manually added (i.e. measures, calculated columns, sort orders, column visibility, etc.).
The solution:
Use the TMDL view!
Open the TMDL view
Right click the table you want to copy
Select "Script TMDL to", then "clipboard"
Open your target dashboard (where you want to paste the table)
Open the TMDL view
Paste the code into the code editor
Click "Apply"
After applying the TMDL script, you'll notice all properties are carried over, so you don't need to worry about manually adding the other stuff like measure, sort orders, etc!
Errors
As of this writing the TMDL view is still in preview, and as such, is experiencing many errors and bugs.
You may get an error about compatibility levels. In which case, you'll need an external tool like Tabular Editor to change it. This setting can be found by clicking on Model, then Database:
Note: This option might be greyed out if depending on your organizations security policies for Power BI.
Comments