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?
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?