Adding a measure to multiple models simultaneously

[Aaron_C]

Hi all,

I cannot find a solution online that will allow me to add a measure to two or more models simultaneously, whether it be locally on your machine, or in service.

Is there a tool for this out there currently?

It seems quite similar to the functionality Measure Killer provides, except I need to add multiple measures instead of removing them.

Help appreciated!

Kind regards,
Aaron

[Aaron_C]

Thank you Marius, I will have to test this out!

-Aaron

[v-yiruan-msft]

Hi @Aaron_C ,

Base on my research, there is no direct method to add a measure to multiple models at the same time directly. Each Power BI model is separate, and measures must be added to each model individually. However, please check if tabular editor can be used as alternative. You can write scripts to create and add measures across different models.

Tabular Editor 3

C# Scripts | Tabular Editor Documentation

Adding measures and other calculated objects | Tabular Editor Documentation

Best Regards

[Aaron_C]

Thank you @v-yiruan-msft , I have a Tabular Editor script that can add multiple measures to a model, on a model by model basis, have not yet found a way to do it for multiple models, as these are standard measures.

Doesn't seem to be an out-of-the-box solution that I have come across!

[mariussve1]

Hi,

It looks like its possible to connect to Power BI with XMLA through Powershell:

https://audministrator.wordpress.com/2021/07/08/powershell-powerbi-xmla-endpoint-examples/

Then it should be pretty easy to create a script for creating measures across datasets