Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Error RSPortal: obtaining a connection from the pool

Hi, we use Oct. 2020 release  (product version 1.9.7627.11028)  and have the following Internal Server Error:   2021-02-01 10:54:28.3246|ERROR|190|OData exception occurred: System.Exception: Rep...
Connection
Report Server
RSPortal
  • ChrisMuthmann's avatar
    ChrisMuthmann
    5 years ago

    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.
Petebro's avatar
Petebro
Microsoft Employee
5 years ago

Thanks for the detail. Are you seeing the number of connections grow with Power BI Reports using direct query or are you seeing it with other types of models as well?

jbarta_mlchc's avatar
jbarta_mlchc
Helper III
5 years ago

Forgot to mention that to test the data source (SSAS Tabular model) for performance issues, I recreated the report/dashboard as a paginated report and the report did not experience the same issue. So i do not believe it is a problem with my tabular model.