The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
94 | |
80 | |
63 | |
56 |
User | Count |
---|---|
248 | |
122 | |
110 | |
77 | |
70 |