Building your first data model

In this example, we'll use Power BI Desktop to walk through the process of importing data and building a simple data model. In the next chapter, we'll look at how to import data using Excel Power Pivot and SSAS Tabular.

If you want to follow along with the examples in the rest of this book, you can download copies of the Access databases and Excel files that are used from: will also find a Power BI Desktop file there that has the tables already imported, to help get you started.

We'll start by importing data from an Access database. From the Power BI Desktop screen, click on Get Data. From the Get Data dialog, select Access database

Get Hands-On Business Intelligence with DAX 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.