Connecting to Excel from SQL Server Data Tools
SQL Server Data Tools also has the built-in feature to Analyze in Excel. When prompted you must select the role or user that you want to connect to the model. Users would not typically leverage SQL Server Data Tools. Therefore, this feature allows you to test the perspectives and security to ensure it is working as designed.
How to do it...
Open Visual Studio and the Crash_Data_Solution.
Click on the Analyze in Excel icon.
On the Analyze in Excel Window, select the role that you want to use. In this case, keep Current Windows User and click OK.
Excel opens using the permissions of the account you selected by creating a new workbook and pivot table.
Select MAJOR_CAUSE as rows and YQMD as columns, and finally add Count_of_Crashes as values to ensure you have successfully connected to the model.
How it works...
This recipe allows you to connect to Excel and explore the data the same way your users see the model. While using SQL Server Data Tools...
