Forum Discussion
Adding a measure to multiple models simultaneously
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
4 Replies
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 datasetsThank you Marius, I will have to test this out!
-AaronHi 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.
C# Scripts | Tabular Editor Documentation
Adding measures and other calculated objects | Tabular Editor Documentation
Best Regards
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!
