I encountered this error "The selected data extension ORACLE is not installed or cannot be loaded. Verify that the selected data extension is installed on the client for local reports and on the report server for published reports." when trying to use "Oracle Database" as a connection type in the SSRS data source in Microsoft Report Builder!
Why I get this error and how I can fix it?
Actually, this error "The selected data extension ORACLE is not installed or cannot be loaded. Verify that the selected data extension is installed on the client for local reports and on the report server for published reports." usually occurs in the following cases:
To be able to use the Oracle Database connection type in a data source in SSRS report Builder, you should make sure that you are using the correct Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio and ODP.NET based on your Oracle Database Server version.
Steps
tnsnames.ora
Don't forget to restart the SSRS service or Power BI report server service in the case you are installing the ODAC and change tnsnames.ora file on the same reporting server.
Note: Oracle Developer Tools for Visual Studio will not be installed if you don't have Visual Studio installed on your current machine, and in this case, you have to uncheck this option during installing ODAC.
Note: In case the above steps don't help, I would recommend using Visual Studio with Bussiness Intelligence Tools Template with ODAC for Visual Studio
Read also
1.1k questions
678 answers
456 comments
193k users
Related Activities
Categories
Most popular tags