Working with data sources and loading data

In the previous recipe, you created the project; now it is time to load data into the model. Unlike other data modeling or data projects you have worked with, the Tabular Model loads the data into the model as soon as you define the data source and specify the data to load. This is a step beyond What You See Is What You Get (WYSIWYG). In this case, you see the data and the effects of all changes you make to it in real time.

The other thing is that you can load all types and sources of data into the model and relate the data after the data has been loaded. Data from a relational database, a text file, a data feed, or even a Power Pivot model can all be loaded into the same Tabular Model for analysis.

Note

In multidimensional models, you will create a data source and then a data source view. The next step is to finish designing the dimensions and measure groups. Once you have completed the design, you will load data. In a Tabular Model, creating the...