Power BI report server October 2020 - hanging issue & 401 (Unauthorized) error

[AsilAllaham]

Hello,

I need help in understating the cause of the following issue:

While using a Power BI report deployed on Power BI report server the report goes into a hanging state (I just get a loading message on the web page) when refreshed and few times the charts used in the report after refreshing the report through F5 gave me an unexpected error message.

* Please note:  that the report has a tabular model in direct query mode as a source and this model was connected to an oracle database using oracle oledb conector.

While tracing the issue I saw the following errors in chrome consoul:

> GET http://10.105.4.27:88/Reports/assets/img/fi/pbirs/manifest.json 401 (Unauthorized)
* Manifest: Line: 1, column : 1, Syntax error.
* GET http://10.105.4.27:88/Reports/assets/img/fi/pbirs/manifest.json 401 (Unauthorized)
* Manifest: Line: 1, column: 1, Syntax error.
POST http://10.105.4.27:88/powerbi/api/explore/reports/43a00e0a-89e2-4176-9b3e-2c02a0a84c77/ conceptualschema 500
(Internal Server Error)
POST http://10.105.4.27:88/powerbi/api/explore/reports/43a00e0a-89e2-4176-9b3e-2c02a0a84c77/ conceptualschema 500
(Internal Server Error)

and at the same time thiss error was loged in RSPowerBI_2020_11_10_09_39_33 logfile:

2020-11-10 10:58:01.8091|ERROR|474|Unhandled error in the Web API|POST http://10.105.4.27:88/powerbi/api/explore/reports/43a00e0a-89e2-4176-9b3e-2c02a0a84c77/conceptualsch... - Response Unknown| RequestID = 332821c7-fb08-ebf0-1962-a90613e0bd92 ClientSessionID = fd9a1fc6-6fd3-0c02-4945-0a90e89567ef System.Exception: ReportServerDatabaseUnavailableException ---> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.BIServer.HostingEnvironment.Storage.MeteredSqlConnection..ctor(String connectionString)
--- End of inner exception stack trace ---
at Microsoft.BIServer.HostingEnvironment.Storage.MeteredSqlConnection..ctor(String connectionString)
at Microsoft.BIServer.Configuration.Catalog.CatalogAccessFactory.NewConnection()
at Microsoft.PowerBI.ReportServer.WebApi.CompositionRoot.Create(HttpRequestMessage request, HttpControllerDescriptor controllerDescriptor, Type controllerType)
at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__15.MoveNext()

-----------------------------------------------------------------------------------------------------

[DavisBI]

Hi, @AsilAllaham ,

Did you have this error before your report server upgraded to PBIRS (Oct-2020) version?

[AsilAllaham]

Hi @DavisBI ,

Yes, in August 2020 I was tasked to build a report on the server on which the issue appeared on. And it had PBIRS Oct-2017 version, so to use the latest version back then I upgraded it to the August-2020 version, I only had one user the admin user, and the report building and deploying process back then worked smoothly.

Moving forward on 09-11-2020 I added a local user that had access to the report, then on 10-11-2020 the issue appeared and I thought that it may be a bug in the Aug-2020 version so I upgrade it to (Oct-2020) and the issue did not go away.

I appreciate your help.

Regards,

[Icey]

Hi @AsilAllaham ,

What's your verification method? Custom authentication? How about swtiching back to windows authentication? Maybe this is the cause.

In addition, is this the case for all reports?

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[AsilAllaham]

Hi Icey,

I used windows authentication {as the user viewing the report} and to answer your second question the server only continued the report which I created and honestly, I did not create any other report to test upon. 

Best Regards,