Time for action – creating the first Power View dashboard

In this example, you will face Power View for the first time. You will also learn how to connect to the SSAS Tabular model through Excel, and then use it as a source for Power View data visualization, as explained in the following steps:

  1. Open an empty Excel workbook, go to the Data tab, and under the Get External Data menu section, click on From Other Sources, and then choose From Analysis Services.
  2. The Data Connection Wizard will appear in the first step. Enter the server name (such as local\Tabular) and click on Next.
  3. In the Select Database and Table tab, choose AdventureWorks Tabular Model SQL 2012, and then choose the Model cube from the main section.
  4. Exit the wizard by clicking on Finish ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial