cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
Newcomer II

Upload Nessus TSCM reports to PowerBI

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 ‘AttributeSmiley TongueluginID’ 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”
Dutch nationality, i am available for ISC2 members with any questions on The Netherlands or the Dutch language.