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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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