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.
How to export and import DAX measures from a Report
Here is the problem statement ….
A data scientist uses Power BI Desktop to create a data model and publishes it to the Power Bi Service.
A developer then uses Power BI Desktop to connect to the shared dataset, creates lots of DAX measures and publishes the report to Power Bi Service. Note the DAX measure are stored in the report and not in the shared dataset.
The data scientist likes the DAX measures and needs to share them. They therefore wants to export then from the report and import them into the Dataset in bulk, rather than copy and paste each measure.
What are the various options and best practice?
Thank you.
Solved! Go to Solution.
Tabular Editor connects to Power BI Desktop, so both the data scientist and the developer would be able to use it.
Thank you John75. it worked a treat !
@onurbmiguel_ Thank you for the reply, but you have given wrong answer to the question. 🙄
There is only one dataset and the dax measure are in the report.
Remeber the quetion is how to export and import DAX measures from a Report.
Not how to export and import DAX measures from a Dataset to Dataset.
Thank you
If you just need to Bulk Copy the measures, you can just select them all in bulk and paste it into new instance of tabular editor.
below are 2 meethods , with
1- Tabular editor as an external tool in Power BI desktop
2- with visual studio code.
Check it out-
HOW DO YOU COPY AND PASTE MULTIPLE MEASURES IN POWER BI | MOVE MEASURES BETWEEN MODELS IN POWER BI
Hello,
we can use ALM Tollkit to compare (if you have 2 datasets):
with this tool you can updated one of dataset in bluk.
My sugestion is to explorer this option.
Best regards
Bruno Costa | Continued Contributor
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍
Take a look at the blog: PBI Portugal
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
Tabular Editor 3 can generate a script to create all the measures, calculated columns etc, which you could then run on the base model. Not sure if that functionality is available in Tabular Editor 2
Thank you John75.
I know Tabular Editor editor can connect to the dataset,
but can it connect to the report?
Then export DAX measure in bulk from the Report and import them to a Dataset?
Remeber the quetion is how to export and import DAX measures from a Report.
Not how to export and import DAX measures from a Dataset to Dataset.
Thank you for your valuable time and sharing knowledge, it is very much appreciated.
Tabular Editor connects to Power BI Desktop, so both the data scientist and the developer would be able to use it.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |