Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
55 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
40 |