Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics

© Dan Clark 2020

D. ClarkBeginning Microsoft Power BIhttps://doi.org/10.1007/978-1-4842-5620-6_2

2. Importing Data into Power BI Desktop

Dan Clark¹ 

(1)

Camp Hill, PA, USA

 

One of the first steps in creating the Power BI analytics model is importing data. Traditionally, when creating a BI solution based on an OLAP cube, you need to import the data into the data warehouse and then load it into the cube. It can take quite a while to get the data incorporated into the cube and available for your consumption. This is one of the greatest strengths of the Power BI model. You can easily and quickly combine data from a variety of sources into your model. The data sources can be from relational databases, text files, web services, and OLAP cubes, just to name ...