The latest build of V2 is available for download at the Microsoft website. V1 lacks a lot of features that were later released in V2, so you should never install V1 today. It was built in 2 distinct versions (V1 and V2). Power Pivot 2010 was written as a plugin as part of the development of SQL Server 2012. This free download works only with Excel 2010, and not with newer versions of Excel. The Power Pivot add-in for Excel 2010 did not ship with Office, but is available as a free download: Power-Pivot add-in download. Power Pivot for Excel 2010 – there are 2 Versions But Microsoft listened to the community and made an announcement that Power Pivot will be made available in “all” Windows editions (“SKUs”) of Excel starting from April 2018! However there are still exceptions with some of the Excel 2013 versions and boxed versions purchased prior to Office 2019. One very common question people ask is “which versions of Excel come with Power Pivot”? Until recently not all Microsoft Office products included Power Pivot. Relationships in Power BI and Power Pivot.Who Needs Power Pivot, Power Query and Power BI Anyway?.The Best Way to Install Power BI Desktop.30 Reasons You Should Be Considering Power BI.Dimensional Modeling (Excel and Power BI).Power BI for the Business Analyst (with live Q&A).

Office 2016 power query