O'Reilly logo

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook by Derek Wilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Browsing your model with Microsoft Excel

Most users will want to use Microsoft Excel to interact with the data and perform analysis. By using Excel you can create many types of interactions with the data in the model. This recipe shows you how to connect to the model and build a Power View report.

How to do it...

  1. Open Microsoft Excel and create a new workbook.
  2. Click on the Data ribbon and then select Get External Data | From Other Sources | From Analysis Services.

    How to do it...

  3. Enter your Analysis Services Server name and Log on credentials on the next window.

    How to do it...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required