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 .
Search WWH ::




Custom Search