If you upgrade to Microsoft Office 2016, which I highly recommend, you will notice that ‘the Power’ has disappeared. With Power I mean, Power Pivot, Power View, Power Query and Power Map. So where did they go and how can I get them back? Actually, they’re not gone, let’s have a closer look.

First you need to verify if the add-inns are still enabled, in the Excel options. You can do this in two ways.

Either you go in Excel Options, Advanced:

exceloptions

Or you go in Excel Options, Add-ins:

enableaddinns

Once you have enabled the plug-ins ad shown here above then look here:

  • Power Query
    Power Query is available in the Data tab, under Get & Transform. There you can select New Query:
    PQ
  • Power Pivot
    Power Pivot is available in the Data tab, under Data Tools:
    PP
    And it’s also available in the Power Pivot tab:
    PP2
  • Power Map
    Power Map is available in the Insert tab, under Tours:
    PM
  • Power View
    Now Power View is an exception. It’s no longer available in the Excel ribbon. The reason is that you can use the, free, Power BI Desktop Designer. Power BI Desktop uses HTML5 for it’s visualizations, while Power View used Silverlight. But you can still enable Power View in Excel 2016.
    To do that, you need to customize the ribbon. Right click on the ribbon and select Customize the Ribbon:
    newgroup
    And then it’s available where you added it:
    newgroup2

So the Power is not gone, it’s still very much alive and kicking 🙂

 


Discover more from think about IT

Subscribe to get the latest posts sent to your email.

2 Thoughts on “Where’s Power BI in Excel 2016?

  1. Pingback: Where’s Power BI in Excel 2016? - Microsoft Dynamics NAV Community

  2. Pingback: Where’s Power BI in Excel 2016? - think about IT - Dynamics User Group

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Post Navigation