Database Reference
In-Depth Information
The selected SQL database views are evaluated and loaded into the data model.
9. In the
Workbook Queries
area, right-click on
IncidentDimvw
and select
Duplicate
from the menu.
10. Right-click on
IncidentDimvw (2)
, select
Properties…
, and rename the query
(for example,
MyIncidentQuery
). Click on
OK
to complete the renaming of
the query.
Explore the data and overview of the interface
Follow these steps to explore and get an overview of the Power BI Excel interface:
1. Right-click on the duplicated query (
MyIncidentQuery
) and select
Edit
.
2.
Query Editor
is opened. It provides an interface to model your dataset, as shown
in the following screenshot: