Database Reference
In-Depth Information
How to do it...
Now let's look at how we can connect to System Center data sources with Power Query.
Connecting to System Center data sources
Perform these steps to connect to a System Center data source:
1. Launch Microsoft Excel, navigate to the
POWER QUERY
tab and to data source
settings, and click on
From Database
.
2. From the dropdown, select
From SQL Server Database
as shown in the follow-
ing screenshot:
3. In the
Microsoft SQL Database
pop-up window, specify the SQL Server name
and database. For this recipe, use the Service Manager data warehouse database as
shown in the following screenshot:
4. Click on
OK
.