Forum Discussion
Unable to generate Report for Realistic load test
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.
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);
}
Community SupportHi Surendarcse92 ,
To clarify, the Power BI Realistic Load Test Tool does not have a built in setting to automatically export to CSV or Excel. If your script lacks export logic, you may need to add it manually. Typically, within the script, there is a section where test results such as response times or logs are stored in a variable or displayed on the console. You can insert a line like this to export the data to a file: | Export-Csv -Path "results.csv" -NoTypeInformation.
FYI:
This PowerShell command saves the output in CSV format. If you need assistance on where to place it, please share part of your script.
Regards,
Yugandhar.
Community SupportHi Surendarcse92 ,
Could you let us know if the issue is still happening or if it has been resolved? If it has been resolved, marking it as the accepted solution would be helpful for others in the community with similar questions.
Thank You.
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);
}
- V-yubandi-msft
Thank you for sharing your workaround. We appreciate your effort in contributing to the community, as it helps others easily. Stay connected with the community for future discussions.
Thank You.