ms-officesharepoint-2013business-intelligencepowerpivotpowerview

how can i use or implement Power BI feature in SharePoint 2013?


I have been using Power BI features in Excel 2013 and was wondering what do I need to do to get them working in SharePoint 2013.


Solution

  • It depends what you mean by the "Power BI" features. Power BI is an Office 365-based product which provides what is, in essence, a cloud-based SharePoint-esque environment for all your self-service BI functionality.

    A lot of this functionality (but not all of it) is also available in SharePoint 2013 (and part of it in 2010).

    SharePoint 2013 Enterprise allows you to make use of the following features:

    To manage/share your Power Pivot models and create Power View reports, you need to be able to add a Power Pivot Gallery to your SharePoint site. This has several prerequisites, including an instance of SQL Server Analysis Services (2012/2014 BI or Enterprise Edition) in Power Pivot mode, and Reporting Services in SharePoint mode.

    To do this, you need to follow the steps outlined in these two articles:

    SharePoint 2013 does not support Q&A (the natural language query component of Power BI).