Forum Discussion
Super UserHow to export and import DAX measures from a Report?
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.
Tabular Editor connects to Power BI Desktop, so both the data scientist and the developer would be able to use it.
7 Replies
- onurbmiguel_
Power Participant
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
johnt75Tabular 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
speedrampsThank 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.
- johnt75
Tabular Editor connects to Power BI Desktop, so both the data scientist and the developer would be able to use it.
PBI_HelplineHelper I
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 , with1- 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- speedramps
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
- speedramps
Thank you John75. it worked a treat !
