Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Thank you Marius, I will have to test this out!
-Aaron
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.
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!
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
User | Count |
---|---|
5 | |
4 | |
4 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |