Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
TableSettings
The partition properties look like this:
PartitionSettings
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:
Model.AddTable("Test2").AddMPartition();
The partition created looks fine after changing the mode to "dual" manually:
PartitionFromScratch
But the table does not have the intended properties and I can not change them manually:
TableFromScratch
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
Thias
Hi @Anonymous ,
Please see if these documents are helpful:
Create Tables, Partitions, and Columns in a Tabular model
Best Regards,
Winniz
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
71 | |
38 | |
29 | |
28 |
User | Count |
---|---|
99 | |
88 | |
62 | |
42 | |
39 |