Add a BI Semantic Model Connection Content Type to a Library (Power Pivot for SharePoint)
Applies To: SQL Server 2016
A BI semantic model connection is created in SharePoint and provides redirection to business intelligence semantic model data in a Power Pivot workbook or Analysis Services tabular model database on a network server. Before you can create a BI semantic model connection in SharePoint, you must extend a document library to allow the creation of a .bism file. This step only needs to be performed once for each library, but you will need to repeat it for any library from which you want to create .bism files. Best practices recommend that you create a centralized library for storing .bism files so that you can manage permissions in one place.
You must have at least the Manage Lists permission to add and configure a content type. This permission is built into the Design permission level and above.
The site that contains the document library must have feature activation for Power Pivot for SharePoint. For more information, see Activate Power Pivot Feature Integration for Site Collections in Central Administration.
Open the document library for which you want to enable the BI Semantic Model Connection content type.
On the SharePoint ribbon, in Library Tools, click Library.
Click Library Settings.
In General Settings, click Advanced settings.
In Content Types, in the "Allow management of content types?" section, click Yes.
In the Content Types section, click Add from existing site content types. If you do not see this page, go back to the site, click Library in Library Tools, and then click Library Settings.
In Content Types, click Add from existing site content types.
In Select site content types from:, select Business Intelligence.
In Available Site Content Types, click BI Semantic Model Connection File, and then click Add to move the selected content type to the Content types to add list.
To verify you added the content type, go back to the library and click New Document on the Documents area of the library ribbon. You should see BI Semantic Model Connection File in the New Documents list.
After you enable the BI semantic model connection content type for a library, you can create a connection that provides redirection to business semantic model data that can be used by Excel or Power View reports. Choose from the following links to learn more about this next step: