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: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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