Abstract
One of the first steps in creating the Power Pivot 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 Pivot 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 a few. This chapter shows you how to incorporate data from a variety of these sources into a Power Pivot model.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2017 Dan Clark
About this chapter
Cite this chapter
Clark, D. (2017). Importing Data into Power Pivot. In: Beginning Power BI. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-2577-6_2
Download citation
DOI: https://doi.org/10.1007/978-1-4842-2577-6_2
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-2576-9
Online ISBN: 978-1-4842-2577-6
eBook Packages: Business and ManagementApress Access BooksBusiness and Management (R0)