Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
danno
Resolver V
Resolver V

DDL / Create Table equivalent for DAX

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

 

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

3 REPLIES 3
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

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

 

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

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.