Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have an SSAS Tabular model where I hide several columns. In Excel 2013 I do not see the columns in the Pivot Table Field List. When I double click on a value and drilldown, the hidden columns appear. What am I missing?
Hi,
The drill down option into Excel is for Power View.
Activate "Power View" complement, then do Insertion > Power View.
It will add a new tab PowerView1 and you can do visualisations or pivot table here.
You can do a drill down now.