Database Reference
In-Depth Information
Adding data to a worksheet and inserting data into
Power View
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
Add this data to the Data Model
unchecked. This will add the data to
a worksheet.
3.
Select the range of cells that contain data that you want to use in your Power
View report. Then, go to the
INSERT
tab and choose
Power View
.
4.
The data will then be displayed in Power View, and in the
Power View
Fields
section, you will see
Range
as the table name with a database icon.
5.
The database icon indicates that data is being imported from a worksheet.
If the data is changed in the worksheet, you can click
Refresh
in Power
View (and also in PowerPivot) to pull in the updated data.
6.
Behind the scenes, it adds the data to a PowerPivot data model with the
name
Range
.
Not adding data to a worksheet and inserting data
into Power View
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. Check
Add this data to
the Data Model
and
Power View Report
(
Power View Report
requires the
Add this data to the Data Model
box to be checked). This does not add data
to a worksheet.
3.
A blank Power View report will be displayed, and in the Power View
Fields
section, you will see the table name (derived based on the name
of the source) without a database icon. A missing database icon means
there is no data in a worksheet.
4.
Behind the scenes, the data is added to a PowerPivot data model with the
same name as the table name in the
Power View Fields
section.