O'Reilly logo

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook by Derek Wilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

  1. Open your model by clicking the Manage icon in PowerPivot to bring up the model window.
  2. Select Get External Data and From Other Sources, scroll to the bottom and select Excel file, and then ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required