Why is Excel using MDX when using Pivot table against a tabular model and not DAX? RRS feed

  • Question

  • I have a tabular model from which I have crated one Excel report and one PowerView report. When I query data in both alternatives I noticed in Profiler that Excel uses MDX and PowerView DAX.

    Will Excel use DAX to query the model in final release?

    I get bad performance in Excel when I add a pivot table with a lot of attributes that results in many detailed rows. In old-fashon SSAS and multidimensional I often use attribute relationsships and show properties in Excel to avoid this. But because that Excel uses MDX instead of DAX I have the samt issue with Cross-joins but in the tabular model I cant set the attributes to appear as properties for a member in Excel.

    Any ideas?

    Thanks / Johan Petersson




    Thursday, February 16, 2012 4:19 PM