How to create multiple measure simultaneously ( at one go )

[ANKITBISANI]

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

[Anonymous · Accepted solution]

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.

[Greg_Deckler]

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

[Anonymous · Accepted solution]

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.

[ANKITBISANI]

Hello @Anonymous ,

Can you please share the link Or a document.

It would be very helpful.

Regards ,

Ankit

[Anonymous · Accepted solution]

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/

[AndyLee]

Hi,

I have been looking for a way to achieve this but the link provided does not work?

Are you aware of another place i may be able to find this information?

Thanks in advance,

Andy

[AndyLee]

Hi,

I have been looking for a way to achieve this but the link provided does not work?

Are you aware of another place i may be able to find this information?

Thanks in advance,

Andy