Upload Nessus TSCM reports to PowerBI

[Lions1970]

Below an Instruction to upload Nessus TSCM reports reports (XML) format to the MS PowerBI tooling, which can be useful to design dashboards for TSCM assessments. 

Monthly upload of Nessus files:

• Load in Power BI the monthly Nessus (XML) file: button ‘New source’ > XML > browse to Nessus file > tick-box table: ‘Report’ > OK
• Add Column > Custom column > column name: ‘Month’ > update formula field (to configure format) with the following format: "10 18".
• Expend the column ‘ReportHost’ (click on double arrow at column top) without ‘HostProperties’.
• Expend the column ‘ReportItem’ (click on double arrow at column top) only with ‘Attribute:pluginID’ and ‘http://www.nessus.org/cm’.
• Filter the column ‘pluginID’ with the value 21156 and delete the column.
• Expend the column ‘http://www.nessus.org/cm’ without ‘compliance-check-id’ and ‘compliance-audit-file’ (note: click ‘load more’ to select ‘compliance-policy- value’).
• Rename the column with IPs as “IP”