Update masterdata tables structure of multiple sem...

mohitleekha1

Hi All,

We are building a new power bi project(pbip) and as part of this we will build multiple datasets(probably around 20) in direct query mode. Although most of these datasets are different and used by differnt team but there masterdata is usually similar(few tables here and there).
So, we want to build a solution that if we need to add a new tables to dataset( or a new column in existing dataset), we do not want to update all the datasets definations manually one by one.

Is there a way we can build some sort of config that all the datasets can pickup automatically.

Thanks in advance.

Regards,

Mohit Leekha

v-tsaipranay

Hi @mohitleekha1 ,

Thank you for reaching out to the Microsoft fabric community forum.

I understand the issue you are facing. When working with multiple semantic datasets, maintaining consistency in master data tables can become time consuming if every dataset has to be updated individually. Out of the box, Power BI does not provide a built-in configuration file that automatically pushes schema changes (new tables or new columns) to all datasets.

The recommended approach is to centralize your master data into a single semantic model and let your other datasets connect to it through composite models. This way, any structural change you make in the master model such as adding a new table or column will automatically flow through to all dependent datasets without requiring manual updates.

If you need more automation across existing datasets, another option is to use Tabular Editor with TOM scripting or deployment pipelines. With this approach, you can define a script or template and apply schema changes programmatically to multiple datasets in one step, instead of editing each one manually.

Provided below Link for your Reference:

Use composite models in Power BI Desktop - Power BI | Microsoft Learn

Hope this helps, feel free to rechout for any further question.

Thank you.