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

Reply
Sean
Community Champion
Community Champion

DAX Studio - List of Measures

Hello ALL,

 

I've been extracting the Measures List per @MattAllington's very good and detailed instructions here for a while now

 

but have always had to copy them from the Results grid in DAX Studio and paste into Excel.

 

I never get the option to Output in Excel as seen in Matt's blog and in the picture below (in the Red rectangle)

 

I've tried with both Excel running and not running... Has anyone else encountered this? Any advice would be greatly appreciated!

 

2016-10-03 - DAX Studio.png

1 ACCEPTED SOLUTION
BhaveshPatel
Community Champion
Community Champion

Hi Sean,

 

The Excel buttons are available when you have installed the DAX Studio Add-in in Excel 2013 or 2016.

 

You should launch your dax studio from here and you can see both the buttons you are looking for. You can see attached screenshot and you can connect to your PowerBI or Tabular or PowerPivot model from here.

Dax Studio Add in in Excel 2016Dax Studio Add in in Excel 2016Excel ButtonsExcel Buttons

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

2 REPLIES 2
BhaveshPatel
Community Champion
Community Champion

Hi Sean,

 

The Excel buttons are available when you have installed the DAX Studio Add-in in Excel 2013 or 2016.

 

You should launch your dax studio from here and you can see both the buttons you are looking for. You can see attached screenshot and you can connect to your PowerBI or Tabular or PowerPivot model from here.

Dax Studio Add in in Excel 2016Dax Studio Add in in Excel 2016Excel ButtonsExcel Buttons

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

@BhaveshPatel Thanks! I kind of expected this to be something small and that's why I didn't ask for so long Smiley Happy

 

You know I've had the Power Pivot Utilites tool for a long time...

 

I still keep it up to date but pretty much have stopped using it since I've transitioned almost entirely to PBI from PowerPivot!

 

So I never even thought about launching DAX Studio from there!?

 

Anyway Thanks again! Smiley Happy

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors