I have a report in Power BI Report Server (May 2020) that is configured with kerberos to use the identity of the current user against the database. Database is connected to using direct query method. SQL 2019 database and PBI May 2020 are on different servers. Kerberos trust was enabled for the databse server for both SQL Server and OLAP services. service account HTTP service was registered as well. kerberos setup works but fails intermittently with one of two errors:
error 1: We couldn't connect to the Analysis Services Server. Make sure you've entered the connection string correctly
error 2: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.. The exception was raised by the IDbConnection interface. Please try again later or contact support. If you contact support, please provide these details.
1.User 1 logins into power bi report server. Opens a report and renders correctly using direct query and displays content. kerberos trust works and user is authorized against the databse and content returned and rendered in the report.
2. User 2 has database login access but no database object read permission gets error #1. Since they don't have database object access.
3.User 3 has no database login access. Gets error #1.
4.Randomly then error 1 starts appearing for people with database access and those without.
Is this a kerberos caching issue on the domain controller or the power bi report server or something else?