Forum Discussion

Ashvini Sharma's avatar
Ashvini Sharma
Icon for Microsoft rankMicrosoft
Oct 07, 2016
It's not in Power Pivot as yet, hopefully soon. Ashvini Sharma Excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 15, 2017

Ashvini Sharma, Olaf Hubel - any news here? And more general question - why DAX for Excel is far behind Power BI Desktop and even SSAS? My guess they use the same engine.

For example, recently introduced TREATAS() for Power BI desktop looks like on hold for Power Pivot.

 

My question is practical - for more or less complex models i prefer to build them in Excel and only on final stage to shift on Power BI Desktop (or directly publish to Power BI services). Above incompatibilities push me to switch directly on Power BI Desktop, but that's not what i'd like to do. 

 

Thank you

  • Mark E Weisman's avatar
    Mark E Weisman
    Copper Contributor
    Feb 15, 2017

    I would think that the fast update path is Excel 2016 on Office 365, but I haven't seen the roadmap.  There are FILTER and INTERSECT alternatives for TREATAS() as mentioned here ... https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Feb 15, 2017

      Mark, i checked the roadmap few days ago (new one) and found nothing. But that doesn't matter. My question is more general - if Power Pivot is considered as legacy tool by Microsfot perhaps i'll shift one day on Power BI Desktop. Even if i don't like this and Excel is much more comfortable for me. 

       

      Yes, why i re-initiated this post since i read mentioned article.

      • Ashvini Sharma's avatar
        Ashvini Sharma
        Icon for Microsoft rankMicrosoft
        Mar 13, 2017

        I seem to have missed this thread. 

         

        Power Pivot isn't legacy, it's a core part of Excel analytics going forward. We're working on improving the quality of experience with the data model & Power Pivot, and for those on subscription, you'll start experiencing slight improvements, initially ~invisible, more focussed on quality.

         

        Part of the work we're doing is to make sure the data model works well with across different versions Excel.. given the wide deployment cycles, we think it's necessary that one person using the latest version of Power Pivot doesn't suddenly cause others downlevel to have data model load failures. As you can imagine, this is substantial work. Once that foundation is laid, updates should be more frequent, we can't wait for that day! 

         

        thanks

        ash

         

        Ashvini Sharma

         

        Excel

         

Resources