Forum Discussion
Error RSPortal: obtaining a connection from the pool
I've worked on this issue with the support. Issue number is 121020321001710.
There is a demo dashboard with Adventure Works Tabular Model and some slicers and filters.
We've fixed the issue by increasing
<MaxCatalogConnectionPoolSizePerProcess> to 500.
Unfortunately enhanced metadata is a one way upgrade so you would have to recreate the report. I am trying now with a DQ report I have adding many more visuals and slicers to it.
As far as config guidance, there really isn't any best practice as our default (100) should be enough for most cases. This is sort of uncharted waters due to this issue. I would say testing double to see if the number of times you end up out of connections is affected at all. However, there could be other consequences from doing this with AS model performance so test this locally in a test environment before setting in production.