Connect a PowerView report to a SSAS Multidimensional (Cube) Source : Quick Tip

Recently I created a Report Data Source Connection to a SSAS Cube for use with Power View in SharePoint 2010. Here’s how I did it:

1. First, open the ‘Report Models’ library in your PowerPivot Site.
2. In the Ribbon, Select Documents tab, and then New Document>Report Data Source.
3. The Data Source properties dialog appears.
4. Name you connection.
5. In the Data Source type select ‘Microsoft BI Semantic Model for Power View’. At first I tried ‘Microsoft SQL Server Analysis Services’, but it didn’t work.
6. In the Connection string, use: data source=ServerName;initial catalog=Analysis Services Database Name;cube=’Cube Name’. I’m not sure you need the single quotes ” around Cube name.
7. Select Windows Authentication. This is required if you Cube has security roles.

Test and Save the Report Data Source. You can then create a Power View report, by clicking the arrow next to the Report Data Source and selecting ‘Create Power View Report’.

More details can be found here – http://msdn.microsoft.com/en-us/library/dn198312.aspx