Database Reference
In-Depth Information
Adding data to a worksheet and using PowerPivot
Follow these steps:
1.
While in a blank workbook in Excel, go to the
DATA
tab and use one of the
options in the
Get External Data
group.
2.
Eventually, you will reach an
Import Data
dialog. Select
Table
and leave the
Add this data to the Data Model
box unchecked. This will add the data to a
worksheet. Or, instead of getting external data, you can type your own data
into the worksheet.
3.
Go to the
PowerPivot
tab, choose
Add to Data Model
, and select the range of
cells that contain data that you want to use in your Power View report. This
changes the selected data on the worksheet into a table and adds it to the
PowerPivot data model with the name
Table1
.
4.
Go to the
INSERT
tab and choose
Power View
. The data will then be
displayed in Power View, and in the
Power View Fields
section, you
will see
Table1
as the table name with a database icon.
If you get the error
A table cannot overlap a range that
contains a PivotTable report, query results, protected cells
or another table
when choosing
Add to Data Model
, go to
DATA
|
Properties
and uncheck
Save query definition
.
This is because when you imported the data, you created an
external data range (also called a query table) and need to
remove the query definition from the sheet to allow it to be
added to PowerPivot.
Not adding data to a worksheet and using
PowerPivot
Follow these steps:
1.
While in a blank workbook in Excel, open PowerPivot by going to the
PowerPivot
tab and choosing
Manage
.
2.
Import data via the
Get External Data
option in PowerPivot. This adds the
data to the PowerPivot data model and gives it a name based on the name of
the source.
3.
Go to the
INSERT
tab and choose
Power View
. Then, a blank Power View
report will be displayed. In the
Power View Fields
section, you will see the
table name without a database icon that is the same name as the Power View
data model. This does not add data to a worksheet.