Forum Discussion
Power BI Report Server - Authentification with Basic Auth
Hi mypbishell ,
In my opinion ,it should be able to coexist.
And request had a 401 status response,there may be two causes for this error.
- The Password Manager Account may not have the correct permissions to access the Reporting Services Server (i.e. Content Creator rights on the SRS Reporting side).
- In complex network environments Windows Integrated Security may fail to authorize the user (client) on the Reporting Services Server because the authorization request is transferred through Password Manager server with impersonated credentials. This case is known as a double-hop issue. A double-hop issue occurs when the SQL Database and the SQL Reporting Services are on two different servers.
and detail soultion ,refer:https://support.oneidentity.com/pt-br/kb/69693/report-server-error-the-request-failed-with-http-status-401-unauthorized
Similar case refer:
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
The documentation does state that NTLM and Basic should be able to coexist.
What sort of authentication is your report data source using? It does state in the documentation for Basic auth https://docs.microsoft.com/en-us/sql/reporting-services/security/configure-basic-authentication-on-the-report-server?view=sql-server-ver15 that the "Windows Integrated" option will not work (this is the "As the user viewing the report" option in the data source settings)