PowerBI Report Server Connection to Remote Oracle Database Fails Using Kerberos

Hi, CJD 

In Active Directory, ensure that service accounts are trusted for delegation to Oracle services. This can be done in the Delegation tab of the service account. Also make sure that you have the correct SPN set up for the service account that is running the report server.
Make sure that the rsreportserver.config file is correctly configured to use Kerberos. The authentication type should be set to RSWindowsNegotiate. You can check this link:

Configure Kerberos to use Power BI reports - Power BI | Microsoft Learn

You also need to see if the Oracle client on the report server is configured to use Kerberos. This involves setting the appropriate Kerberos parameters in the sqlnet.ora file. 
Check if there are any network issues or firewall rules blocking Kerberos traffic between the report server and the Oracle database server. You can refer to this post:

Solved: Oracle database connection error in Power BI Repor... - Microsoft Fabric Community

Now that Kerberos logging is enabled, check the logs for any Kerberos-related errors. You can also enable verbose logging for the report server for more details. Check that you're using an Oracle client version that's compatible with your Power BI Report Server. You can check the following link:

Set up the Oracle connection type with SSRS and a Power BI report server - SQL Server Reporting Services (SSRS) | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.