https://community.isc2.org/t5/Member-Support/Upload-Nessus-TSCM-reports-to-PowerBI/m-p/18194#M3529 <P>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.&nbsp;</P><P>&nbsp;</P><P><STRONG>Monthly upload of Nessus files:</STRONG></P><UL><LI>Load in Power BI the monthly Nessus (XML) file: button ‘New source’ &gt; XML &gt; browse to Nessus file &gt; tick-box table: ‘Report’ &gt; OK</LI><LI>Add Column &gt; Custom column &gt; column name: ‘Month’ &gt; update formula field (to configure format) with the following format: "10 18".</LI><LI>Expend the column ‘ReportHost’ (click on double arrow at column top) <STRONG>without</STRONG> ‘HostProperties’.</LI><LI>Expend the column ‘ReportItem’ (click on double arrow at column top) only with ‘Attribute:pluginID’ and ‘<A href="http://www.nessus.org/cm’" target="_blank">http://www.nessus.org/cm’</A>.</LI><LI>Filter the column ‘pluginID’ with the value 21156 and delete the column.</LI><LI>Expend the column ‘<A href="http://www.nessus.org/cm’" target="_blank">http://www.nessus.org/cm’</A> <STRONG>without </STRONG>‘compliance-check-id’ and ‘compliance-audit-file’ (<STRONG>note:</STRONG> click ‘load more’ to select ‘compliance-policy- value’).</LI><LI>Rename the column with IPs as “IP”</LI></UL> Mon, 09 Oct 2023 09:05:32 GMT Lions1970 2023-10-09T09:05:32Z https://community.isc2.org/t5/Member-Support/Upload-Nessus-TSCM-reports-to-PowerBI/m-p/18194#M3529 <P>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.&nbsp;</P><P>&nbsp;</P><P><STRONG>Monthly upload of Nessus files:</STRONG></P><UL><LI>Load in Power BI the monthly Nessus (XML) file: button ‘New source’ &gt; XML &gt; browse to Nessus file &gt; tick-box table: ‘Report’ &gt; OK</LI><LI>Add Column &gt; Custom column &gt; column name: ‘Month’ &gt; update formula field (to configure format) with the following format: "10 18".</LI><LI>Expend the column ‘ReportHost’ (click on double arrow at column top) <STRONG>without</STRONG> ‘HostProperties’.</LI><LI>Expend the column ‘ReportItem’ (click on double arrow at column top) only with ‘Attribute:pluginID’ and ‘<A href="http://www.nessus.org/cm’" target="_blank">http://www.nessus.org/cm’</A>.</LI><LI>Filter the column ‘pluginID’ with the value 21156 and delete the column.</LI><LI>Expend the column ‘<A href="http://www.nessus.org/cm’" target="_blank">http://www.nessus.org/cm’</A> <STRONG>without </STRONG>‘compliance-check-id’ and ‘compliance-audit-file’ (<STRONG>note:</STRONG> click ‘load more’ to select ‘compliance-policy- value’).</LI><LI>Rename the column with IPs as “IP”</LI></UL> Mon, 09 Oct 2023 09:05:32 GMT https://community.isc2.org/t5/Member-Support/Upload-Nessus-TSCM-reports-to-PowerBI/m-p/18194#M3529 Lions1970 2023-10-09T09:05:32Z