Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Anonymous
‎02-09-2021 01:15 AM

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

 

 

 

 

Labels:
Comments