Using Power BI to Analyze and Visualize System Center Data - Microsoft System Center Reporting - page 445

11. Click on the Id column in the target ( RuleView ) as the target merge column.
Then click on OK .
12. Click on the double arrow icon to the right-hand side of NewColumn , uncheck
Select All Columns , select Name , and then click on OK .
13. Click on Merge Queries from the ribbon. Note that you do not need to select a
new source. The result of the previous query (the extended Performan-
ceDataAllView view) is the source (top part of the Merge dialogue box).
14. Click on the little arrow in the lower pane of the Merge window and select
BaseManagedEntity as the target.
15. Click on the NewColumn.BaseManagedEntityId column in the extended source
( PerformanceDataAllView ).
16. Click on the BaseManagedEntityId column in the target ( BaseManagedEntity )
as the target merge column, and click on OK .
17. Click on the double arrow icon to the right-hand side of NewColumn , uncheck
Select All Columns , select Path , and then click on OK .
18. Click on the arrow icon to the right of NewColumn.Name . Uncheck Select All .
Type Mi-
crosoft.Windows.Server.6.2.LogicalDisk.FreeMB.Collection
in the search box, and then click on OK .
19. In the ribbon, click on Close & Load .
20. Save the Excel.
21. This is the base query for the recipe in this section of the chapter.

The following table lists what is required to complete this recipe:

Requirement or information Description

Dataset as described in the Getting ready section Use a pre-created dataset for logical free disk space data. This is the saved Excel workbook.

This table will serve as an input for the tasks required to complete this recipe.