DDL / Create Table equivalent for DAX

[danno]

Hi,

I'm interested to know if its possible to create a DDL statement for PowerBI so that I can construct a table of measures from one model and move it to another model for consolidation.  There is no copy / past between pbix files currently (https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/14114169-allow-copy-and-paste-bet...but I'm hopeful it will be implemented soon.

In the meantime, it would be good if I could use DAX studio to get hte Measure statements for a table, and then (semi-automatically) create a statement that would create the table in the PowerBI file from DAX studio.  we have large measure tables, and need to consolidate / reuse measures. 

Is an equivalent DDL CREATE statement for DAX/ PowerBI? 

Dan

[TomMartens · Accepted solution]

Hey,

I'm do not believe that it is possible from inside DAX Studio to exctract the Measure definition from certain tables and use these definitions to create in tables in new PBIX files.

But maybe you want to give the TabularEditor a try, this editor allows to "script" a model and also automate some steps. The TabularEditor is available here: https://github.com/otykier/TabularEditor

and also mentioned here: https://www.sqlbi.com/tools/tabular-editor/

It's possible to use Tabular Editor to connect to a local PBIX file.

Please be aware that Tabular Editor does not officially support the change of PBIX metadata or even the "creation" of tables inside a PBIX model, but maybe this will help you somehow.

Regards

Tom

[danno]

Good to know that's available, shame there isn't just a copy / paste ability.  thanks for the pointer

[danno]

Good to know that's available, shame there isn't just a copy / paste ability.  thanks for the pointer