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...

Get Tabular Modeling with SQL Server 2016 Analysis Services Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.