Facing slowness in SSRS report rendering with custom security implementation to support OIDC
Our application uses SSRS reports with embedded XML Data source. Reports are having multiple sub reports and sub reports are added dynamically based on data. Reports are rendering correctly with Windows Authentication.
We have implemented SSRS Custom Security implementation to support OIDC authentication in Microsoft Reporting Services to support a new security requirement.
With this we are setting "No Credentials" for data source but report rendering is taking too much time ( Data Retrieval time is increased by 40 times). Further checking AdditionalLogInfo from ReportServer DB logs we can see ConnectionOpenTime/DataRetreival is increased considerably.
Any suggestion on why DataRetreival/ConnectionOpenTime taking time with OIDC with same data/reports ?