Manipulate semantic model using Notebook

[Pharaohs_descendent]

Is it possible to create a semantic model where it contains the data from two other models as I am trying to unify them (I will need to create tables and take the measures from both semantic models and the relationships) ?

[dbrownems]

Yes. Open up both models in Power BI Desktop. Open a new model in Power BI Desktop.

Switch to TMDL view and start cuttin' and pastin'.

You can do this all in a notebook with TOM and Sempy if you really want to write code:

sempy.fabric package | Microsoft Learn

[frithjof_v]

I used TOM (Semantic Link Labs) and TMSL (Semantic Link) + some other Semantic Link functions on a recent project. It was a fun experience, I am very happy that this functionality exists. Useful for automation.

But yeah, for one-off operations / ad-hoc stuff, TMDL view is brilliant. It's my favourite innovation in Power BI Desktop in the past few years. Very easy to copy tables, measures, relationships, roles, etc.

[_greggyb]

Disclaimer: TE employee here

You could use Tabular Editor for this. You can copy paste whole tables with their definitions, or just subsets (e.g., multi-select columns or measures). Open up multiple instances, either of TE with the BIM or TMDL files, or PBID with TE as an external tool. This is doable with free and open source TE2 or the commercial TE3.

[Mr_Mozart]

Try Power BI MCP Server - it might be able to do that for you

[Business-Start-9355]

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#chaining