When adding the bookmark guid as well as other filters, getting the error in HTML pages and load testing is not running properly.
Kindly help in fixing this issue.

Json File

Getting below error after providing the number of reports to configure.

Login-PowerBI : The term 'Login-PowerBI' is not recognized as the name of a cmdlet, function, script file, or operable
program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At C:\Users\Jeby.Jacob\Downloads\PowerBI-Tools-For-Capacities-master\PowerBI-Tools-For-Capacities-master\RealisticLoadT
estTool\Setup_Load_Test.ps1:75 char:13

• $user = Login-PowerBI
  

What if you want to test a report with multiple tabs and you want to test the performance for each tab. Is it possible to do this currently?

thank you!

I am receiving parse errors as below, while executing .\Initiate_Load.ps1 of LoadTestingPowerShellTool . Please find below the image. Kindly help.

I was wondering if testing a report under the "Worst Case Scenario" would be good enough if it has multiple pages. Since only the first page of the report is generally displayed in the Chrome window that gets opened, would that be enough to load all the data in a report created with "Data Import" and no live connection to a backed DataSource? Would the % utilization shown by PowerBi-Embedded Metrics be a good way to determine what sized SKU would suit our needs best?

Thanks.

I've set up the script without a problem and everything seems to work as expected. When I fire the Realistic Load Tool.ps1 my report starts rendering in about 2 sec. Passing the 20 page refreshes mark the approximate time of refresh keeps getting slower and slower and the most time is spent in "Loading report..." spinning wheel. After 50 refreshes the reported refresh time goes up to over 12 sec. Above 70 refreshes Chrome window becomes unresponsive and report is not rendering. Tracing data requests in SQL profiler is reporting the same approximate processing time of DAX query and moreover there are less DAX queries logged against data model as Chrome page refreshes pile up.

It means there is less traffic against the report and data model is not under pressure over time. This gives an indication that the delay is on client side. Anyone experienced the same problem?

can launch RealisticLoadTestTool manually and opens in chrome with pbi report
but when i launch using powershell as run as admin, the chrome browser is launched but it comes blank..

Hi, I need sample json to take in date range as filter values.
E.g
Begin period date = 2018-09-01
End period date = 2018-09-15

Hi everyone,
I'm running 10 sessions of the realistic load test script on a powerful machine with good connection and after 7 minutes I get this error in the image on this link: https://github.com/andreajanicijevic/PowerBI-tests/blob/main/Load%20test%20error.png

Issue with cookie with app.powerbi.com/ domain
How to solve it?

Attempting to update the script to support Edge Chromium, I leveraged the below documentation but was unsuccessful. Can you please investigate adapting this script for use with the Microsoft Edge version?

"--user-data-dir=""Edge\Profile$profile""

URL: https://docs.microsoft.com/en-us/deployedge/edge-learnmore-create-user-directory-vars

Example:
start msedge.exe "--user-data-dir=""Edge\Profile$profile"" --disable-default-apps --new-window ""$($reportHtmlFile)"""

Can we filter the test by string-like (Region Name = MW, etc) instead of min and max values?

currently, the output is the browser . How do you enable logging and write to the filesystem

I've followed the instructions meticulously to try this tool.
Loaded "Power Bi Load Testing Demo.pbix" to a workspace and configured all the details of "PBIReport.JSON" with my url.
When opening the HTML, the report loads on the page, but I get the error in Chrome Dev Tools:
Failed to load resource: net::ERR_NAME_NOT_RESOLVED

RealisticLoadTest.html:250 Uncaught TypeError: Cannot read property 'models' of undefined
at EmbedReport (RealisticLoadTest.html:250)
at RealisticLoadTest.html:485

Also tried running several times: .\Update_Token_Only.ps1 in PowerShell but the result is the same.

When running the RealisticLoadTest tool, we see the following exception;

RuntimeException: C:\Users\adam.riddick\Downloads\PowerBI-Tools-For-Capacities-master\RealisticLoadTestTool\Run_Load_Test_Only.ps1:63
Line |
  63 |              $profile = ($profile+1) % $numberOfPhysicalCores;
     |              ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | Attempted to divide by zero.

Cause by this line

(Get-WmiObject –class Win32_processor).NumberOfCores;

It appears there may be a missing pre-requisite to have Microsoft.PowerShell.Management loaded.

We need to have the ability to pass a list as filters instead of just minimum and maximum values.

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

When running .\Run_Load_Test_Only.ps1 on a single report, a chrome window opens and the report fails to load, anywhere up to 15 times, before the report then loads and the test begins.

Typically this is with a 403, but we have also seen 429's being reported as the error. It seems the tool does try again, but as there is no warning it appears to the end user that something has gone wrong and they could cancel the test without knowing.

It appears that navigating to bookmarks in a bookmark group isn't working. The workaround for the moment is moving it outside of a group. It shows an unhelpful "undefined" error message.

I'm inquiring here how to navigate to a bookmark in a bookmark group:
https://community.powerbi.com/t5/Issues/Power-BI-Embedded-getBookmarks-not-working-with-grouped-nested/idc-p/924457/highlight/true#M53304

I’m trying to understand how the number of users simulation works. Read me mentions that (average of window load + estimated real time user use) / average of window load = real time user number.

I have 20 windows open. Each represents a different page in one report. Each of these pages loads at a different average time. How can I estimate how many average users are using this report if each page will provide a different user account?

Summing all those results seems unrealistic since it will be a very large user count.

My end goal is to simulate around 200 users on one workspace with multiple multi page reports.

I'm testing a report (PBIX) with A1 SKU attached to a workspace.
After last prompt, it just launches Chrome window (blank). No report output. Just the frame with boxes.

Not sure what is missing. For Filters I have slicer
Enter Filter values separated by comma(,). Ex:TableName,ColumnName,100,1000: Date,Year,CY2019,CY2020

I'm able to run this tool. However, it seems filters are not being applied, no error is shown

In my PBIReport.JSON I can see:

reportParameters='{"reportUrl":"https://app.powerbi.com/reportEmbed?reportId=XXXXXX&groupId=XXXXXXX&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly9XQUJJLVBBQVMtMS1TQ1VTLXJlZGlyZWN0LmFuYWx5c2lzLndpbmRvd3MubmV0IiwiZW1iZWRGZWF0dXJlcyI6eyJtb2Rlcm5FbWJlZCI6ZmFsc2V9fQ%3d%3d","filterStart":201901,"filterMax":201912,"sessionRestart":100,"filterTable":"cub vwPeriod","filterColumn":"AX_MONTH_SHORT"}';

which make sense to me.

Fact table is of course related to 'cub vwPeriod' table but the report iterate over and over again on the same period "201912" I see no changes when running on browsers

any idea?

Good Morning Greg,
Currently the load scripts is using AAD to authenticate, can we change the script to use ServicePrincipal ?
Or the LoadScript will not work with ServicePrincipal, period, it's just the way that it's setup ?

Just want to do a sanity check with you. Thanks!

can launch RealisticLoadTestTool manually and opens in chrome with pbi report
but when i launch using powershell as run as admin, the chrome browser is launched but it comes blank..

Hello all,
It's my first time running this tool, and this error "Cannot retrieve contributors at this time" showed up in pop-up screen (attached) after I confirmed "y" in PS script that I "want to launch configured reports" and it didn't proceed. Appreciated your help or advice on this!

I'm unable to run the Load Assessment Tool script. You mention Setup_Load_Test.ps1 in a few issues but I don't see it anywhere. When the Chrome browser opens, the URL and dashboard are empty. In looking in the debugging mode of Chrome (see below), it seems like the last line of the script isn't passing the arguments to Chrome.

On adding custom data in the filter, I m getting duplicate values in the visuals.

"filters": [ { "filterTable":"Summary", "filterColumn":"Domain", "isSlicer":true, "filtersList":["domain0","domain1","domain10"] }, { "filterTable":"Summary", "filterColumn":"Template", "isSlicer":true, "filtersList":["template0","template19","template9"] ]

Looks like missing JSON files:

PBIToken (JS Object File) file which stores Aad access token for the connections to work.
PBIReport (JS Object File) file which stores report parameters including report url, filter parameters.

could you double check

Hi Team
Am getting am Uncaught 'filters property is Invalid' error in the PBIESinglePageUOD_noADAL_event_filter_loop.html file. This appears to occur regardless of filter settings entered.
All prerequisites are in place (elevated and PowerShell plugins). Am logging onto a virtual machine (that has www and admin access) with a pBI service account. So all line of sight issues addressed.

Attached is basic pbix, filter is set for 'all pages'

Filter criteria: dimDates, dtmCalYear, 2013,2017

cb1.zip

Any light shedding appreciated

EDIT: This is also happening with Realistic Case Tool using demo pbix and filters

Cheers

Chris

unable to login power in china
Login-PowerBI only works for ms global, however, in China the URL is different

From what I can tell, this doesn't appear ready for GCC, GCC High and/or DOD. Is there any plans to ensure that this will run in the GCC, GCC High, DOD arena?

Thank you

Hello, i'am wondering how can you add on the URL the RLS roles that can help to test reports with an RLS solution.
Thanks in advance !
BTW : very nice projet ! thank you