topic Re: Adding a measure to multiple models simultaneously in Developer

Adding a measure to multiple models simultaneously

Aaron_C — Tue, 13 Aug 2024 13:53:22 GMT

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

Re: Adding a measure to multiple models simultaneously

mariussve1 — Tue, 13 Aug 2024 14:23:31 GMT

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

Re: Adding a measure to multiple models simultaneously

Aaron_C — Tue, 13 Aug 2024 14:40:29 GMT

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

-Aaron

Re: Adding a measure to multiple models simultaneously

Anonymous — Fri, 16 Aug 2024 08:04:23 GMT

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

Re: Adding a measure to multiple models simultaneously

Aaron_C — Thu, 22 Aug 2024 13:05:14 GMT

Thank you @Anonymous , 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!