Forum Discussion

anuj1085's avatar
anuj1085
New Member
1 year ago
Solved

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   ...
  • V-yubandi-msft's avatar
    V-yubandi-msft
    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.

  • Surendarcse92's avatar
    Surendarcse92
    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);

        }