Forum Discussion
Solved
Power BI Scale-Out Caching Master\Slave
All; We have an On-Prem Power BI (Native Mode) environment. We have two nodes in Scale-out. The nodes are identical. What we are finding is that scheduled SSRS report caches run faster when th...
What we found was that with the paginated reports contention was created by the server attempting to run the same queries at the same time.
Our solution was to found here ...
we found that the Power BI reports continued to be refreshed from both servers, but the paginated reports were force to run on only one. This solved our concurrency issue.
What we found was that with the paginated reports contention was created by the server attempting to run the same queries at the same time.
Our solution was to found here ...
we found that the Power BI reports continued to be refreshed from both servers, but the paginated reports were force to run on only one. This solved our concurrency issue.