Adding data to Power Pivot
Now that you have a working model in PowerPivot, you will enhance your SQL Server data that was imported with new external data that is stored in Excel. You will add new data from an Excel sheet that contains codes for two other columns. This is an example of how users can continue to enhance corporate data and make the model more useful for all people that need to leverage the data.
Getting ready
This recipe requires the Crash_Data_PowerPivot_new_tables.xlsx Excel data that is available from the Packt Publishing site.
How to do it...
- Open your model by clicking the Manage icon in PowerPivot to bring up the model window.
- Select Get External Data and From Other Sources, scroll to the bottom and select Excel file, and then ...
Get Tabular Modeling with SQL Server 2016 Analysis Services Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
