Error while modifying SSRS report using Report Builder: Data extension ORACLE is not installed

Question

While trying to modify a SQL Server Reporting Services (version 13.0.5026.0) report using the Microsoft Report Builder, I am receiving the error: "The selected data extension ORACLE is not installed or cannot be loaded." I installed ODAC 18c Release 1, but the error still occurs.

Answer 1

Hi @cship,

You may follow the official documentation which provided by Oracle to connect to Oracle source in SSRS.

This step by step tutorial guides how to configure Microsoft SQL Server Reporting Services (SSRS) connectivity to Oracle.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

One guy said he resolved this problem this way:

= = = = =

Install [Oracle Client for Microsoft Tools]

https://www.oracle.com/database/technologies/net-downloads.html

First, i uninstalled all Oracle components on SSRS Server.

After, i installed 64 bits version on SSRS Server side and 32 bits version on client side executed ReportBuilder.

= = = = =

Seems worth trying. He had exactly the same error.

Also, Joyzhao from Microsoft posted here about the same issue: https://learn.microsoft.com/en-us/answers/questions/826929/report-builder-creating-oracle-data-source-works-b

And also, similar discussion here: https://community.fabric.microsoft.com/t5/Desktop/Power-BI-Report-Builder-Oracle-Connection-Issue/td-p/2905281