Feedback by UserVoice

Raymond Wong

My feedback

  1. 501 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      Hi all,

      I’m happy to announce that your input has had another direct impact on the product. In this case, a decision has been made to have Power Pivot be available in all Windows editions (“SKUs”) of Excel! This means the Business, Home, Standard, etc.. all of these will have Power Pivot. As your comments have indicated, Power Pivot has moved from targeting a specialized audience to generally useful capability for working with data in spreadsheets. As such, it makes sense to make this as broadly available as possible.

      We have started rolling this change out with the April Current Channel updates (Builds 9330 and beyond). I’m also happy to announce that these SKU changes will be reflected on the upcoming 2019 version as well.

      Thank you for pushing for this!

      Ashvini Sharma
      PM Manager
      Excel

      Raymond Wong commented  · 

      Thank you Ashvini Sharma for making this happen.

      I updated Office365 Business today and see the "Manage Data Model" button" under "Data" tab.

      Raymond Wong commented  · 

      Thank you Ashvini Sharma for making this happen.

      Raymond Wong commented  · 

      Hi Ashivini,

      The power bi data engine/model is already available in Excel 2016 Office365 and you can connect when creating a PivotTable using "external data source".

      However, it feel like MS deliberately CRIPPLE the functionality by removing the PowerPivot menu and other feature to manage data engine/model.

      I understand MS push to PowerBI desktop. There are a few key major reasons to use Excel instead of powerbi desktop.

      1. Power bi desktop does not have ANY print function. I have to send the data out to the Powerbi cloud/Service in order to print any reports from powerbi desktop. Why?

      2. In powerbi desktop, I cannot create a report table by combining bespoke data points such as impression, visits, transactions by same date and some business category in power bi.

      In Excel, I can look up each metric from different worksheets or workbooks and combine them into a single table template for managers. The ability to combine bespoke data points is a major advantage that Excel has over other BI reporting tools.

      Raymond Wong commented  · 

      I just discovered that there is a work around to use the pivot-table with the data model loaded by PowerQuery in Excel 2016 Business edition. The step are
      1. Power Query choose to load data into data model
      2. Insert PivotTable and select "Use this workbook's Data Model
      3. You can create DAX measures in the PivotTable Fields UI by right clicking on a table icon.
      4. You can use Date -> Relationships to link tables

      What I found out was part of PowerPivot functionality is in Excel 2016 Business BUT without the PowerPivot UI to get all the features.

      Raymond Wong commented  · 

      My understanding is that Powerbi desktop (free) share the same data engine as the PowerPivot in Excel. Yet, PowerPivot is not available in all version of Excel. After upgrading from Office 2010 to Office 2016 Business, Excel lost PowerPivot completely.
      Powerbi desktop is great but cannot create data solution/analysis like PowerPivot in Excel. This is because I can feed the data from Powerpivot to another worksheet for further calculation. I also mention this aspect in Powerbi forum. I do not understand MS decisions. There are way more users of Excel. If MS want more people to adopt Powerbi ecosystem, let them have powerpivot in Excel. This will allow any data analyst to learn how powerful the data engine is. They will want Powerbi for sharing data across the organization. Yet MS decided to limit access to an upsell version of Excel and block a large community of Excel User to dip their toes in the data engine.
      I found out about Powerpivot because I needed a solution to carouse a data and Excel files when I was using 2010. Company upgraded to 2016 business and lost PowerPivot. I am limping along with Powerbi desktop and Powerbi Pro service but not the most satisfactory solution because once your data is in Powerbi desktop you cannot get them back in Excel without manual export from the grid widgets. The other way is to upload the data into the cloud and bring in back to Excel with the “Analyze in Excel” - doing the data round trip. If you do not have internet access, you are doomed. Powerbi Desktop IS not Excel and will not replace Excel. - end my rant.

      Raymond Wong supported this idea  · 

    Feedback and Knowledge Base