Running a report from report server with DirectQuery to Oracle getting this error
An unexpected error occurred. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.
We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.:
Request ID: c5796563-fbd5-eaa6-7877-a340df8ea2d2
Time: Thu Dec 03 2020 09:53:28 GMT+1100 (Australian Eastern Daylight Time)
Service version: /powerbi/libs
Already tried the following:
- The report works from the desktop
- Converting the report to import mode and using the same Oracle data source works. Also scheduling the refresh with this import mode on the server works
- when checking the data sources to do a test connection get this error An attempt has been made to use a data extension 'Oracle' that is either not registered for this report server or is not supported in this edition of Reporting Services.
- Checked the Oracle client version and the steps to register the .NET as covered in https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view...
Also on a side note, noticed that the option 'Oracle' is not showing up as a connection type when trying to add a new data source directly from the Power BI report server portal. Not sure if that is related.
Are there any other setting that we may have missed?
Environment:
- Power BI report server May 2020
- Data source Oracle 12.c
