Forum Discussion
Copy and Paste a Query
You can copy a table and columns in a query, but you can't copy DAX measures stored in a table by copying the table.
in my PBI desktop; when in Data view; the tables list on right allow right click and 'copy table'......but I can't see anywhere/any way to paste. In open space on the right frame there is no action and the paste icon in ribbon is inactive.
what am I missing?
no problem in copying queries when in Edit Query screen.... these data tables that I can not copy discussed above are actually queries.... so if that is the reason why they cannot copy/paste in the Data view - - what table can copy/paste? only that which has not had a query applied to it?
What i think is even when we try to create a measure with the same name in other queries in our PBI Desktop it won't allow.
if we consider that, then if we want to copy a table we are going to copy with measures(whicih actually leads to create a copy of a query with the same Measure names and column names) which should not happen and so we are unable to paste it.
But its happening at query editor cus derz no option to define calculated measures at query level except a custom column So we can duplicate a query in query editor. (I guess)
I think my confusion is - before one is at the Query Editor - I refer to this screen as table data view - on the right frame one is able to right click and select 'Copy Table'...... but there is no ability then to Paste.
My theory at the moment is that it is because the table has had query steps applied to it - though I don't know if this is correct. It could be that I don't understand the user interface. But right now I think if Copy is enabled then Paste should be enabled also - and this point has me baffled.....
The point on measures not copying is also interesting for me.