Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to: Add Table with Tabular Editor with ObjectType "Dual" and Source "M"

Hi all, 


I started to work with tabular editor and if I open one of our existing Power BI Models the table properties are set like this: 


The partition properties look like this: 


Now I have the need to rebuild such a configuration from scratch. So I did the following scripting in a new created model with tabular editor 2: 


 The partition created looks fine after changing the mode to "dual" manually:


But the table does not have the intended properties and I can not change them manually:


This seems to happen because a standard partition is also created from the script. After deleting this second partition it also looks good. 


Now my questions: 

How can I code the script in a way, that my properties will be set in the right way from scratch?

I did some investigation on TOM and Tabular Editor 2. And tried some syntax. But it did not worked out.

Maybe someone can show me the link to the Appendix A mentioned here:  Advanced Scripting | Tabular Editor Documentation

and give me some hints, how the syntax is working. I even do not find out how to delete the automatically created - but not needed - default partition using a script. 


Best regards



Community Support
Community Support

Hi @Anonymous ,


Please see if these documents are helpful:


Create Tables, Partitions, and Columns in a Tabular model 

Model Class 



Best Regards,

Not applicable

Hi @v-kkf-msft ,


sorry I tried different variations looking like this: 



but I get only error. I am using tabular editor and opening up a new model. I want to script the model without any database connection. This is going to be implemented as an m-code in the partitions of the created tables. Therefore the example given here, seem not to fit: Create Tables, Partitions, and Columns in a Tabular model 

Actualy, I think it is my fault, because I know nothing about C# and do not know were to start at least. 

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors