To do that, you need to customize the ribbon. But you can still enable Power View in Excel 2016. Power BI Desktop uses HTML5 for it’s visualizations, while Power View used Silverlight. The reason is that you can use the, free, Power BI Desktop Designer. It’s no longer available in the Excel ribbon. Power Map is available in the Insert tab, under Tours: Power Pivot is available in the Data tab, under Data Tools:Īnd it’s also available in the Power Pivot tab: Power Query is available in the Data tab, under Get & Transform.

In this video I demystify the differences so you know how these amazing to. Once you have enabled the plug-ins ad shown here above then look here: Many people are confused about the difference between Power Query and Power Pivot. You can do this in two ways.Įither you go in Excel Options, Advanced: So where did they go and how can I get them back? Actually, they’re not gone, let’s have a closer look.įirst you need to verify if the add-inns are still enabled, in the Excel options. With Power I mean, Power Pivot, Power View, Power Query and Power Map. If you upgrade to Microsoft Office 2016, which I highly recommend, you will notice that ‘the Power’ has disappeared.

Power pivot in excel 2016