Cloud version only – not available with on-premise SharePoint. Power BI Q&A: Included with Power BI SItes. Cloud version only – not available with on-premise SharePoint (only works with data from SharePoint online). Power BI for mobile: An app you download.
Works with Windows 7, Windows 8, Windows Server 2008 R2, and Windows Server 2012. Cloud version only – not available with on-premise SharePoint.ĭata Management Gateway: This is a client agent ( download) that enables cloud access for on-premises data sources on your server and exposes data from these on-premises data sources as OData feeds for corporate-wide access via Power Query. On this SharePoint Online site you will be able to add a “Power BI sites” application that allows you to share workbooks and use other BI features. Power BI Sites: If you are accepted to the Power BI for Office 365 preview you will be given a SharePoint Online account.
On-premise only (does not work with Excel Web App and can’t upload to SharePoint). Works for 32-bit or 64-bit, but 64-bit is highly recommended. It requires Excel 2013 – Excel 2010 is not supported. Power Map: Is an Excel add-in that you download and install. On-premise (Excel and SharePoint) and cloud version (read-only in SharePoint online or Excel Services). Requires Microsoft SharePoint Server 2010 Enterprise Edition, Reporting Services 2012 in SharePoint integrated mode and Analysis Services. Can also be used through SharePoint: run the SQL Server 2012 install (Business Intelligence edition or Enterprise Edition) and on the Feature Selection page choose “Reporting Services Add-in for SharePoint Products”. There is not an add-in version for Excel 2010. Power View: Included with Excel 2013, you just need to enable it. On-premise only (does not work with Excel Web App, but a Power Pivot Data Model can be read in SharePoint online).
If you have Excel 2010, you need to download and install it. Power Pivot: Included with Excel 2013, you just need to enable it.
On-premise only (does not work with Excel Web App). It requires Excel 2010 SP1 or Excel 2013. Power Query: Is an Excel add-in that you download and install.
Each of the products that comprise Power BI for Office 365 have different requirements: Power BI is an Office 365 marketing offering (see pricing). “Power BI” is an umbrella name for a lot of products, which I explain at Power BI first impressions (also I have a video at Power BI for Office 365 video).