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.
- Open Microsoft Excel and create a new workbook.
- Click on the Data ribbon and then select Get External Data | From Other Sources | From Analysis Services.
- Enter your Analysis Services Server name and Log on credentials on the next window.