Forum Discussion
Unable to generate Report for Realistic load test
- 1 year ago
Hi Matt_B75 ,
It appears you have already completed the essential troubleshooting steps, including running PowerShell as an administrator, verifying your access token, and checking the working directory for output files. However, the CSV or Excel report is still not appearing. It is possible the report is saved in a subfolder or under a different name, so please search the entire working directory for .csv or .xlsx files.
Additionally, not all versions of the tool support automatic export, so please review the script settings to confirm whether export options are enabled. If export is not supported, you may need to manually extract the data from the logs. Also, check if any results or logs are stored in designated folders such as Results or Logs, as these might contain the test output.
Thank You.
- 1 year ago
I have managed to write some code on my own and update the html file. Now I am able to export that in csv using below function
function downloadCSV() {
let csv = "Load Number,Timestamp,Duration(ms),Avg Render Time(ms)\n";
renderLogs.forEach(log => {
csv += `${log.loadNumber},${log.timestamp},${log.durationMs},${log.avgRenderTimeMs}\n`;
});
const blob = new Blob([csv], { type: "text/csv;charset=utf-8;" });
const link = document.createElement("a");
link.href = URL.createObjectURL(blob);
link.download = "powerbi_load_test_results.csv";
link.style.display = "none";
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
}
I have a very similar issue. The tests run as they should, i've only set them with basic tests at the moment. The process runs and completes without error. Chrome windows are displayed, with a view of the page and refresh times in the top section. From the information i have this should then output a excel/csv file containing the results. in the intructions i've seen this is output within the directory im working from, but i cant see anywhere that this is being output to. Running Poweshell with admin, cannot see where the results or logs may be. Access token is up to date. Any help would be appreciated
TIA
Matt
Hi Matt_B75 ,
It appears you have already completed the essential troubleshooting steps, including running PowerShell as an administrator, verifying your access token, and checking the working directory for output files. However, the CSV or Excel report is still not appearing. It is possible the report is saved in a subfolder or under a different name, so please search the entire working directory for .csv or .xlsx files.
Additionally, not all versions of the tool support automatic export, so please review the script settings to confirm whether export options are enabled. If export is not supported, you may need to manually extract the data from the logs. Also, check if any results or logs are stored in designated folders such as Results or Logs, as these might contain the test output.
Thank You.