Using Analyze in Excel from SSMS

Often you will have users that use SQL Server Management Studio (SSMS) to write queries or browse data. When you are using SQL Server Management Studio to browse the cube, there is an easy way to quickly connect to Excel to interact with your model. Built into the browser in SSMS is a feature called Analyze in Excel. Once clicked the data and connection that you are viewing is lifted into Excel for further exploration.

How to do it...

  1. Open SQL Server Management Studio and connect to your Tabular Service. Right-click on the database model, Crash_Data_SSASTM, to analyze and select Browse....

    How to do it...

  2. Once the browser opens, ...

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.