Note the use of a calendar table in the DATESINPERIOD. It is pretty common to have a “date” dimension & I’ve used it the DateKey from the dimension as the “date” column which is required by the DATESINPERIOD function.
You can use the above example as a starting point now.
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.
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.
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!