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!
Solved! Go to Solution.
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 2016
Excel Buttons
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 2016
Excel Buttons
@BhaveshPatel Thanks! I kind of expected this to be something small and that's why I didn't ask for so long
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!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
105 | |
72 | |
68 | |
47 | |
47 |
User | Count |
---|---|
161 | |
85 | |
76 | |
68 | |
67 |