Creating a tabular model on transactional data

We are now going to create a model based on unprepared data. There are cases where building on the transactional system may be your best option due to business or other technical reasons. This allows you to build an analytics solution without necessarily building out a data warehouse. This process will use Power Query extensively to build out the solution.

We will start the process by adding another SSAS tabular project to our solution. Let's name this one WideWorldImportersPQ for Power Query. Let's get started on our new model:

1. Add a new data source to the model. This time, we will be connecting to the transactional database we restored, WideWorldImporters.
2. Next, we will import the tables. Right-click the data source and select Import New Tables. Here is the list of tables to select in the navigator: Application.TransactionTypes, Sales.CustomerCategories, Sales.Customers, and Sales.CustomerTransactions.
3. Once...