powerviewmapsRead an official Microsoft Power View page and you will see that “Power View is an interactive data exploration, visualisation, and presentation experience that encourages intuitive ad-hoc reporting”.     Power View reports actually look pretty sweet too… there a bunch of things that Power BI does that Power View doesn’t, but all in all the visuals are appealing, and it’s a neat, fresh single click experience for a business user to explore data.

Read an official Power BI page and you will see that “Power BI is a suite of business analytics tools to analyse data and share insights… Monitor your business and get answers quickly with rich dashboards available on every device“.

Sounds very similar to Power View, but Power View was happening 5 years ago.   Things have changed since and in the last 12 months in particular, but one of the stand-out differences between Power View and Power BI is “Every Device“.  Power BI has mobile apps available on Windows mobile, Android, IOS… has a nice cloud portal which can be accessed via the browser of any device and features Power BI Desktop, which runs on any device with the help of thin app or virtual machine technology.

Power BI runs rings around Power View, and with that Silverlight dependency, it is fast moving into Depreciated territory….

  1. An official Microsoft Power View page still reads…. “Power View is a feature of Microsoft Excel 2013, and of Microsoft SharePoint Server 2010 and 2013 as part of the SQL Server 2012 Service Pack 1 Reporting Services Add-in for Microsoft SharePoint Server Enterprise Edition”… Sound very yesterday ?
  2. Power View isn’t configured out of the box in SharePoint 2016 – you need to install the SQL 2016 add-ins Turn on Power View in SharePoint 2016.
  3. Excel in Office 2016 has Power View completely hidden. You’ve got to go turn it on in the ribbon otherwise you wouldn’t know it is even there Turn on Power View in Excel 2016

powerviewexampleFurther, and probably foremost, Power View now lives in the shadow of Power BI hysteria.. Power View now certainly feels like its days are numbered…. but there’s one gap in Power BI which won’t let Power View die just yet… and that is On-Premise Data Exploration capability.   Power View is still the number 1 choice … and the visuals actually aren’t too shabby.  Check out all the awesome Power View videos and you will see…


There’s one more On-Premise alternative and that’s Power BI deployed to a Pyramid Analytics server.

Pyramid Analytics was the key collaborator with Microsoft to develop Power BI.    From Power BI Desktop you can deploy to a Pyramid Analytics server as shown below.   It’s NOT Free though, and convincing your business to invest more again in a Pyramid Analytics as a short term tactical decision, might be as unappealing as waiting 18 months for Microsoft to deliver Power BI visualisation in an On-Premise browser.   What do you do in between ?   The alternative of course is Power View…. which is Dead, but won’t die for these compelling reasons…





One Comment

Leave a Comment

Your email address will not be published. Required fields are marked *