Add-ins for Excel 2010 were released which included Power Pivot and Power Query. This was required to lay the foundation for the base technology to really catapult the transformation of BI as you know it. This began with the introduction of Power Pivot and Power View functionality introduced in SQL Server 2012. Microsoft has been putting tremendous effort into changing the game of Business Intelligence, wrenching it from the clutches of data analyst / report creator / SQL guru (think PerformancePoint 2007, SQL Server Reports, SQL analysis and integration services) and making it accessible for the savvy business user.

How Did We Get Here? And What’s Power BI? “Bring the power of data to every user in your organization” In your Office 365 Message Center, you might have seen this message on the right. Honestly I believe it’s for the better, but there are a few things that still haven’t come to fruition. I’ve been wondering when this would happen for quite a while now, and its finally happened. It had a good run, but Microsoft is finally killing off the initial iteration of Power BI to let its new service move in and run the show. As it happens with Microsoft products, there are two competing versions of the same thing and eventually one gets phased out.

How to get power query in excel 2013