Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
speedramps
Super User
Super User

How 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.

1 ACCEPTED SOLUTION

Tabular Editor connects to Power BI Desktop, so both the data scientist and the developer would be able to use it.

View solution in original post

7 REPLIES 7
speedramps
Super User
Super User

Thank you John75. it worked a treat !

 

 

 

speedramps
Super User
Super User

@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

PBI_Helpline
Helper I
Helper 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 , 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

onurbmiguel_
Power Participant
Power Participant

Hello, 

we can use ALM Tollkit to compare (if  you have 2 datasets): 

http://alm-toolkit.com/

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 

 

wp-1586527108426

 

 


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 


 


johnt75
Super User
Super User

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.