Report Builder Connection to OLE DB

[MajedAK]

Hello,

I am able to connect to OLE DB on Power BI Desktop, however when trying to use Report Builder (OLE DB Data Sources are defined on the on-premise report server), I am receiving the following error 

The 'OraOLEDB.Oracle' provider is not registered on the local machine.

I have tried to also install ODAC 32bit for Report builder but as my Windows version is 64bit, it did not work.

Any ideas?

[v-kpoloju-msft]

Hi @MajedAK,

May i know has your issue been resolved? If the response provided by the @Anonymous, @Poojara_D12, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[v-kpoloju-msft]

Hi @MajedAK,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-kpoloju-msft]

Hi @MajedAK,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[Poojara_D12]

Hi @MajedAK 

The error you're encountering, "The 'OraOLEDB.Oracle' provider is not registered on the local machine," occurs because the Oracle OLE DB provider required for connecting to an Oracle database isn't properly installed or registered on your system. In Power BI Desktop, you may be able to connect to the OLE DB provider because it might be using a different version (possibly 64-bit), or it might have been configured to work with the correct architecture. However, Report Builder, which runs in a 32-bit context, requires the 32-bit version of the Oracle Data Access Components (ODAC) and the Oracle OLE DB provider.

Since your Windows is 64-bit, installing the 64-bit version of ODAC alone won't resolve the issue in Report Builder, as it specifically requires the 32-bit provider to work with 32-bit applications. To fix this, you need to install the 32-bit version of ODAC alongside the 64-bit version to ensure that the 32-bit Oracle OLE DB provider is available for Report Builder. Make sure to download the correct 32-bit ODAC version from Oracle's official website and follow the installation instructions to register the provider on your system. After doing so, the error should be resolved, and you should be able to connect to your Oracle data source in Report Builder.

[Anonymous]

Hi, @MajedAK 

You can refer to the following official documentation to configure ODBC:

Set up the Oracle connection type with SSRS and a Power BI report server - SQL Server Reporting Serv...

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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