{"id":230985,"date":"2022-10-27T18:00:00","date_gmt":"2022-10-27T17:00:00","guid":{"rendered":"https:\/\/www.virtualworlduk.co.uk\/wordp\/?p=230985"},"modified":"2022-10-27T14:19:25","modified_gmt":"2022-10-27T13:19:25","slug":"skyline-basic-power-bi-report-part-1","status":"publish","type":"post","link":"https:\/\/www.virtualworlduk.co.uk\/wordp\/skyline-basic-power-bi-report-part-1\/","title":{"rendered":"Skyline – Basic Power BI Report – Part 1"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

As you will have seen over my last few posts, I’ve been working with VMware Skyline a bit recently.\u00a0 I really like Skyline and believe that more companies should utilise it to provide proactive findings on their environments and to help avoid issues before they become and issue.<\/p>

One area that Skyline has been lacking in the past is around the reporting side of things.\u00a0 This has gotten better as new updates are released but sometimes you just want to have more of a summary page to see what is going on in your environment or to be able to share with managers.<\/p>

This blog post is designed to help you to create and provide a Basic Power BI Report utilising export data from Skyline.\u00a0 It’s a bit of a walkthrough document to produce something similar to the screenshot at the top of the blog but also serves as a starting point to enhance your Skyline reporting capabilities, with the limited data that is available through the export files from Skyline.\u00a0 You could look to add conditional colouring to the cells or lines based on Criticality; you could look to order the findings based on the number of affected objects; you could create sparklines to show how the number of affected objects per risk type change over time.\u00a0 There are so many different options available but we’ll start with the basics in this post and then you can enhance it however you wish.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Getting export files from Skyline<\/h4>
The first thing that we need for our report is to have a data source.\u00a0 In this instance, we will be using a Skyline export as our data source.\u00a0 The Skyline export is received as a csv file.\u00a0 If you want to show a findings trend line as shown in the version above, then you will need to have multiple export files in a folder… with just a single export file, you will just see a dot for the trend line.<\/div>
You should already have Skyline configured and connected to your environment and see findings listed in Skyline Advisor.<\/div>
Once you are in Skyline Advisor, go to the ‘Findings & Recommendations’ link at the top of the screen.\u00a0 With ‘Active Findings’ shown, click the ‘Export’ button.\u00a0 The page should look similar to below, and after clicking the ‘Export’ button, a csv file should begin to download:<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Before we leave Skyline Advisor, click the ‘Findings Catalog’ link at the top.\u00a0 This will take you to the full catalog of the findings available in Skyline at that time.\u00a0 If you scroll down to the bottom of the page, you will see that you are being shown findings 1-50 of the total number of findings.\u00a0 You should make a note of the total number of findings listed, as this will be used later to help work out the percentage of the Total findings that your findings represent.\u00a0 At the time of writing, the total number is 1076, although this number changes on a monthly basis.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Create the Folder Structure<\/h4>

We’re going to keep the folder structure quite simple but I would recommend creating a new folder to house the Power BI report, with a sub-folder that will house all of the Skyline exports that you’ll create over time.\u00a0 Once you have the folder structure created, make sure you move the export file you have just downloaded into that subfolder.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Create Your Power BI Parameters<\/h4>

We’re going to create the parameters that we’re going to need for the report (when creating your own reports in future, you may decide to create parameters at a later date to make data locations etc. customisable by your report users).\u00a0<\/p>

The steps that I will describe in this blog post will utilise Microsoft Power BI Desktop installed on a Windows 11 PC, although the method would be the same on a Windows 10 PC as well.<\/p>

Start up Power BI Desktop and you’ll be presented with a blank starting screen, similar to below:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

We’re primarily going to be using two main components of Power BI… the report\/design screen shown above and the data transformation screen.\u00a0 The data transformation screen can be accessed by clicking the ‘Transform data’ button at the top of the screen… you should see something similar to below:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

We now need to click on the ‘Manage Parameters’ option at the top of the screen to open the parameter management screen, as shown below:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Hopefully, you’ve followed me so far.\u00a0 Now if you click on the ‘New’ link within the ‘Manage Parameters’ window, you’ll have the option to create the first parameter.<\/p>

In this report, we’ll utilise two parameters.\u00a0 The first parameter is the total number of findings available in Skyline at that time.\u00a0 The second parameter will allow the user to enter the location where the Skyline export files are located.<\/p>

Let’s start with the first of these parameters:
Under the Name box, enter:\u00a0 Number of Findings
You can enter a description of the parameter, if you wish.
Tick the box that says ‘Required’
In the Type drop-down box, select ‘Decimal Number’
In the Suggested Values drop-down box, select ‘Any value’
In the Current Value box, enter the current number of findings recorded earlier (if you remember at the time of writing this was 1076)<\/p>

Once you have finished with that parameter, click the New link again to enter the second of our parameters with these settings:
Under the Name box, enter:\u00a0 FileLocation
You can enter a description of the parameter, if you wish.
Tick the box that says ‘Required’
In the Type drop-down box, select ‘Text’
In the Suggested Values drop-down box, select ‘Any value’
In the Current Value box, enter the full path to where the export files are located.\u00a0 Do not include the specific export file name.<\/p>

Once you have done with these, click ‘OK’ to accept them.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

You will now also see the parameters listed under the ‘Queries’ section on the left.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Create Other Queries<\/h4>

With our parameters now in place, we can work on the additional queries that will be used to help present the data on screen.<\/p>

Whilst we are still in the ‘Power Query Editor’ that we used for the parameters, click the drop down link under ‘New Source’ and select ‘Blank Query’<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

We’re going to create a quick ‘Transform’ query using the ‘Advanced Editor’ capability before creating our main query further on in the blog post.\u00a0 This Transform query will help to transform the data as required as we step through the data manipulation later in the report.<\/p>

With the blank query listed on the left, right mouse click on the query and then left click rename, and rename the query to be:\u00a0 Transform File<\/p>

Right mouse click on the query again, then left click on ‘Advanced Editor’.\u00a0 A new page will open up, you should replace all of the text in the box with the following:<\/p>

let
Source = (Parameter1 as binary) => let
Source = Csv.Document(Parameter1,[Delimiter=\",\", Columns=8, Encoding=1252, QuoteStyle=QuoteStyle.Csv]),
#\"Promoted Headers\" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
#\"Promoted Headers\"
in
Source<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Repeat the process to create a new query.\u00a0 This time we want to rename the query to be called:\u00a0 Sample File<\/p>
You should right mouse click on the new query, then left click on ‘Advanced Editor’.\u00a0 In the new page, replace all of the text in the box with the following:<\/p>
let
Source = Folder.Files(FileLocation),
#\"Sorted Rows\" = Table.Sort(Source,{{\"Date created\", Order.Descending}}),
#\"Filtered Rows\" = Table.SelectRows(#\"Sorted Rows\", each not Text.StartsWith([Name], \"~$\") or not Text.EndsWith([Name], \".pbix\")),
#\"Kept First Rows\" = Table.FirstN(#\"Filtered Rows\",1),
Navigation1 = #\"Kept First Rows\"{0}[Content]
in
Navigation1<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Repeat the process to create a new query.\u00a0 With our blank query listed on the left, rename the query to be called:\u00a0 LatestFile<\/p>
We can now use the query bar to add in a source, by entering the following into the query bar:<\/p>
= Folder.Files(FileLocation)\n<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
As you can see, after pressing enter, you’ll see the details of the file listed.<\/p>
We’ll perform some additional formatting on the data that is now available from this source.<\/p>
We’re going to sort the files by descending order by date, which isn’t a problem when there is a single file but when we have multiple files in the folder, we want to work with the latest file.\u00a0 Then we’re going to filter the files to only show .csv files (just in case you accidentally put other files in the same folder).\u00a0 Next, we’re going to only keep the first row, as we want to focus on the most recent file.\u00a0 We’ll then start to Transform the file so that we don’t look at the file information but instead the data within the file.\u00a0 We’ll rename some columns and remove columns that are no longer required, before expanding the data within the file and changing the column types to the relevant type for the data in each of the columns.<\/p>
Each of the following lines will be an additional step on the query that we have been working on.\u00a0 To add a new step, right mouse click on the ‘Source’ applied step on the right of the screen and left click on ‘Insert Step After’.\u00a0 In the query bar, remove everything that is listed and replace it with the first line below.<\/p>
= Table.Sort(Source,{{\"Date modified\", Order.Descending}})

<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Right mouse click on the step that has just been created, and then click ‘Rename’ and enter a new name for the step as:\u00a0 Sorted Rows<\/p>
Create a new step, rename it as: Filtered Rows<\/p>
Paste the following into the query bar:<\/p>
= Table.SelectRows(#\"Sorted Rows\", each ([Extension] = \".csv\"))<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Repeat the process again, with the new step being renamed to:\u00a0 Kept First Rows<\/p>
Paste the following into the query bar:<\/p>
= Table.FirstN(#\"Filtered Rows\",1)<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Repeat the process again, with the new step being renamed to:\u00a0 Filtered Hidden Files1<\/p>
Paste the following into the query bar:<\/p>
= Table.SelectRows(#\"Kept First Rows\", each [Attributes]?[Hidden]? <> true)<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Repeat the process again, with the new step being renamed to:\u00a0 Invoke Custom Function1<\/p>
Paste the following into the query bar:<\/p>
= Table.AddColumn(#\"Filtered Hidden Files1\", \"Transform File\", each #\"Transform File\"([Content]))<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Repeat the process again, with the new step being renamed to:\u00a0 Renamed Columns1<\/p>
Paste the following into the query bar:<\/p>
= Table.RenameColumns(#\"Invoke Custom Function1\", {\"Name\", \"Source.Name\"})<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Repeat the process again, with the new step being renamed to:\u00a0 Removed Other Columns1<\/p>
Paste the following into the query bar:<\/p>
= Table.SelectColumns(#\"Renamed Columns1\", {\"Source.Name\", \"Transform File\"})<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Repeat the process again, with the new step being renamed to:\u00a0 Expanded Table Column1<\/p>
Paste the following into the query bar:<\/p>
= Table.ExpandTableColumn(#\"Removed Other Columns1\", \"Transform File\", Table.ColumnNames(#\"Transform File\"(#\"Sample File\")))<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Repeat the process again, with the new step being renamed to:\u00a0 Changed Type<\/p>
Paste the following into the query bar:<\/p>
= Table.TransformColumnTypes(#\"Expanded Table Column1\",{{\"Source.Name\", type text}, {\"Finding Id\", type text}, {\"Issue Description\", type text}, {\"Severity\", type text}, {\"Number of Affected Objects\", Int64.Type}, {\"First Observed\", type date}, {\"Risk if no Action Taken\", type text}, {\"Recommendations\", type text}, {\"Reference\", type text}})<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
At this point you should have something similar to below shown on screen, with all of the applied steps and the additional Transform File and Sample File queries.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
At this point you should remember to click the ‘Close & Apply’ button in the top left of the screen to return you to the Power BI report design screen, at which point you should also save the report to avoid losing any data.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
This continues in Part 2 of this walkthrough which is available here:\u00a0 https:\/\/www.virtualworlduk.co.uk\/wordp\/?p=231022<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"
As you will have seen over my last few posts, I’ve been working with VMware Skyline a bit recently.  I really like Skyline and believe that more companies should utilise it to provide proactive findings on their environments and to help avoid issues before they become and issue. One area that Skyline has been lacking in the past is around […]<\/p>\n","protected":false},"author":1,"featured_media":230988,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[9],"tags":[],"class_list":["post-230985","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-vmware"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-content\/uploads\/2022\/10\/2022-10-21-15_22_05-Skyline-Insights-1.0-Community-Power-BI-Desktop.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts\/230985","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/comments?post=230985"}],"version-history":[{"count":27,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts\/230985\/revisions"}],"predecessor-version":[{"id":231079,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/posts\/230985\/revisions\/231079"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/media\/230988"}],"wp:attachment":[{"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/media?parent=230985"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/categories?post=230985"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.virtualworlduk.co.uk\/wordp\/wp-json\/wp\/v2\/tags?post=230985"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}