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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous

How to get all the DAX expression (Measures)from power bi file with DAX Studio

I was looking for a solution for how can I get all the DAX measures in Excel from Power BI

I haver found multiple articles but nothing was work out for  me

Then I found DAX studio which is provided free in SqlBI Website in DAX Studio

I have found the option from where I can get the this done in just 10 mins.

Below are the steps.

 

Open DAX Studio. select your file

Go to DMV.

PIC 1.jpg

 Click on DMV

Select MDSCHEMA_MEASURES

PIC 2.jpg

Click on this  and then Run 

 

PIC 3.jpg

You will see the table will come in the result.

PIC 4.jpg

Copy this table in the Excel  You can find your solution..

 

PIC 5.jpg

 

 

 

 

Comments