Add the BI Semantic Model Connection Content Type to the SharePoint Library
- Go to the SharePoint Library site that will host the connection file, click the Library in the Library Tools.
- Click the Library Settings
- In the General Settings section, select the Advanced settings
- In the Content Types, Select the Allow management of content types to be Yes, then click OK
- In the Content Types section, Click on the Add from existing site content types
- Add the BI semantic Model Connection
- After click on the OK button, you can see the BI Semantic Model Connection added in the Content type table
Set Up Permissions
- Grant the Tubular Model Analysis Service administrative permissions to the SharePoint Service Account.
- Grant the user who is going to use the connection with the Read permission on the Tabular Model database
- Add a Role with Read permission
- Adding the user to the Role
Create the Connection File on SharePoint
- Go to the library page, click on the Documents in the Library Tools.
- Click on the down arrow on the New Document and select the BI semantic Model Connection.
- On the New BI Semantic Model Connection page, specify the server name and database name and then Click OK.
- On the library page, you should be able to see the new connection file.
Use the BISM Connection in SharePointNow you may use Excel or Power View to consume the BISM connection file as the data source.
- If you create the file in PowerPivot Gallery, you could click on either the Open New Excel Workbook or Create Power View Report link on the right upper corner to open the application.
- If you create the file in the Shared Documents page, you could click on the Down Arrow on the File Name to launch either the Excel or the Power View Report.