Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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/
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
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.
Hello @Anonymous ,
Can you please share the link Or a document.
It would be very helpful.
Regards ,
Ankit
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/
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |