Forum Discussion
Unable to generate Report for Realistic load test
Hi,
I have been trying to the run the realistic load test for power BI with available here on github.
I am to run it successfully but I am unable to get the CSV/Excel Report for the load
It will great if I can get some pointer for this please help.
Power BI Realistic Load Test Toll - Blank Chrome window
Thanks
Anuj
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);
}
12 Replies
Could you please guide us to setup the export option "Ensure the CSV/Excel export is enabled in the script settings."Where it should be updated ?
Hi 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.
Hi 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.
Hi anuj1085 ,
Thank you for contacting the Microsoft Fabric Community. It appears your test is running smoothly, but the CSV/Excel report is not generating as expected.
- Ensure the CSV/Excel export is enabled in the script settings.
- Check the Results, Logs, or Output folders for the report.
- Verify file permissions. PowerShell may require Administrator privileges to write the CSV.
- If the script does not support automatic export, manually extract the data from logs using Power BI, Excel, or a Python script.
- If using the Realistic Load Test Tool, ensure your access token is current by running Update.
If you need further assistance, please let me know.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
Hello anuj1085 ,
Could you please confirm if your issue has been resolved or if you require any further information? If the issue is resolved, kindly mark it as the Accepted Solution to assist other members who may encounter similar issues.
Thank You.
Hi anuj1085 ,
We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.
Your feedback is valuable to us, and we look forward to hearing from you soon.
Thank You.
Hi anuj1085 ,
Has your issue been resolved, or do you require any further information? Your feedback is valuable to us. If the solution was effective, please mark it as 'Accepted Solution' to assist other community members experiencing the same issue.
Thank You.
