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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Exporting Measures to a text file

Is there a way to "export" all teh Measures/DAX code to a text file from a PBIX file?

1 ACCEPTED SOLUTION
v-eachen-msft
Community Support
Community Support

Hi @Anonymous ,

 

You could export to a Power BI Templates file and open it with text.

Here is the document for your reference.

https://visualbi.com/blogs/microsoft/powerbi/exporting-measure-column-formulas-power-bi/

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

7 REPLIES 7
kunalrathi55
Regular Visitor

 

Steps to export measures from Power BI file.
1. Save the Power BI file as Power BI Template (.pbit)

Export-Power-BI-measurs-from-pbix-file.gif

2. Run the PowerShell script mentioned in this article to export all measures and calculated column expressions from the Power BI template file.

balu810
Frequent Visitor

Open DAX Studio -> on left hand table pane -> right on any table ->Define All Measure(All Tables)

 

You will have all the measure in the text format on the right hand pane

That worked a treat. just delving into Dax Studio Now. Looks pretty exicting that and Tabular Editor. 

 

Thanks

v-eachen-msft
Community Support
Community Support

Hi @Anonymous ,

 

You could export to a Power BI Templates file and open it with text.

Here is the document for your reference.

https://visualbi.com/blogs/microsoft/powerbi/exporting-measure-column-formulas-power-bi/

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.
jdbuchanan71
Super User
Super User

Hello @Anonymous 

Take a look at the Vertipaq Analyzer.  It is an excel plug-in from the SQLBI.com team that can hook into a model and extract information and measures / calculated column formulas.

https://www.sqlbi.com/tools/vertipaq-analyzer/

vertipaqmeasures.jpg

Anonymous
Not applicable

I will download this add-in.. can you comment on how this relates to a PBIX file that contains the measures?

 

thanks,

Ray B.

They have directions on the site about how to modify the connection string so you can point it to your model.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.