Database Reference
In-Depth Information
Getting ready
Chapters 4 to 8 of this topic provide information about data sources for reporting. You can
use the same sources as the input for your Power BI queries.
You must have a fully deployed and functioning System Center 2012/R2 Service Manager
Data Warehouse to complete this recipe. The following functionality in Power Query for
Microsoft Excel 2013 is described in these recipe sections:
• Connecting to System Center data sources
• Exploring the data and overviewing the interface
• Extending the query data
• Adding date and time functions to Power Query
The following table lists what is required to complete this recipe:
Recipe requirement or information
Description
Service Manager's
DWDataMart
database is the System Center data source for
this recipe
System Center data source connections in Microsoft Excel
In the
There's more
section, refer to the additional data source
example
Orchestrator
database
Microsoft Excel
Version 2013
