Skip to main content
Microsoft Idea

Synapse

Needs Votes

Add support for programmatic manipulation of semantic model via sempy

Vote (6) Share
Tim Spannagel's profile image

Tim Spannagel on 20 Feb 2024 07:21:12

The semantic-link library has huge potential. It would be really beneficial if semantic models could also be manipulated via code.


It would be great to see something like the following methods:

  1. Add a new measure fabric.addMesaure(dataset,workspace, dax)
  2. Add new table to semantic model (basically an extension of to_lakehouse_table() where i can also add it to a semantic model e.g. fabric.add_table_to_semantic_model(fabric_df, semantic_model, table_name)
  3. in addition to 2. a function to create relationships in a semantic model: fabric.create_relationship(semantic_model, table1, table2, key_column1, key_column2, infer_cardinality)
  4. Add an option to plot_relationship_metadata() to show all columns

Ruixin Xu (administrator) on 26 Apr 2024 05:49:26

Thanks for the idea. We have it in our backlog. No ETA to share at this moment. To help us prioritize this idea, please consider voting for it.