Forum Discussion
How to create multiple measure simultaneously ( at one go )
Hello Team ,
I want to create 50 measures and I have defined those in notepad.
Now , I have to do the following steps 50 times in order to create new meausres .
1. Create new measure
2. Copy/write a defination of the measure
3. SAVE the same.
I have 50 measures defined with me in a notepad.
Is there any other options , where I could paste 50 measure defination and it will get created in one go.
Regards,
Ankit
- Anonymous9 years ago
Other than praying they add an api, the only thing I can think of is to do it in Excel 2016 (the object model lets you add measures), then import the excel file into PBI Desktop.
- Anonymous9 years ago
Object model method to add measures in Excel:
https://msdn.microsoft.com/en-us/library/office/mt574976.aspx
Import into Power BI:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-excel-workbooks/
6 Replies
- Greg_DecklerCommunity Champion
I am not aware of a way to do that today. Presumably this idea would solve it so maybe vote for the idea:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7345565-power-bi-designer-api
- AnonymousNot applicable
Other than praying they add an api, the only thing I can think of is to do it in Excel 2016 (the object model lets you add measures), then import the excel file into PBI Desktop.
- ANKITBISANIAdvocate I
Hello Anonymous ,
Can you please share the link Or a document.
It would be very helpful.
Regards ,
Ankit