So you are SharePoint site admin and your task is to extend Document Library to connect to SSAS Tabular Model so that your Power View reports can connect to Tabular models. we’ll see that in this blog-post.

Note: Creating a SharePoint Business Intelligence Dev Environment is a different thing, please refer: Bird’s Eye view of SharePoint BI Dev Environment Setup process and official reference http://msdn.microsoft.com/en-us/library/hh231687%28v=sql.110%29.aspx

In this Blog Post, I am assuming you are through step 1- 8 and we’ll see a Tutorial on Step 9: “Extend the Document Libraries to include BISM connections.” so that we can create Power View reports on Tabular Models.

Here are the steps:

1) Open SharePoint PowerPivot site

2) PowerPivot site > Documents > Do you see New Document disabled? Well, we are going to fix that!

3) Switch to PowerPivot Gallery > Library > Click on Library settings:

4) Click on advanced settings

5) Here change the setting of “Allow Management of Content Types?” to YES

And Click on OK

6) Back on Document Library Settings Page, Under Content Types, click on “Add from existing site content types”

7) On “Add Content Types” Page > from Available Site Content Types – Add “BI Semantic Model Connection” to content types to add. and click on OK.

8) Now,

Go to PowerPivot Gallery > Documents > New Document.

Can you see BI Semantic Model connection? Yes? Awesome!

9) Now let’s test it.

Note: I am on my Dev Machine so I am going to test it by just connecting a Tabular Model that’s running on same machine.

Click on OK.

10) can you see the connection? Yes? Click on Power View icon.

11)Can you see the view? yes? Go ahead! Create Awesome Power View reports!

That’s about it for this post.