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.
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi again,

I was able to narrow down the problem:

Some of our older Live Connection Power BI reports don't even open one connection via RSPortal to SQL Server, while others keep increasing the number of connections with each new click (filter, drill down).

 

I opened one of the old Power BI reports (build with  a 2019 desktop version)  in my up to date Desktop Version (Oct. 2020) and saved it again to PBIRS.

Now, with each click in this new Version the number of connections increase and i am able to reproduce the error mentioned  above. 

 

Looks like a bug in the Desktop Version.

Please advise.

Petebro's avatar
Petebro
Microsoft Employee
5 years ago

Ah let me engage with someone from the desktop team that is more familar with that area I will be back with investigation outcomes.

 

Though would it be possible to setup an enviroment using the January release of PBI RS And PBI RS Desktop to ensure this wasn't already fixed since October?