Forum Discussion

MajedAK's avatar
MajedAK
Frequent Visitor
1 year ago

Report Builder Connection to OLE DB

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?

OLE DB
report builder
Support

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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 Services (SSRS) | Microsoft Learn

     

     

     

    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.

     

     

  • Poojara_D12's avatar
    Poojara_D12
    Super User
    1 year ago

    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.

     

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Community Support
    1 year ago

    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's avatar
      v-kpoloju-msft
      Community Support
      1 year ago

      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's avatar
        v-kpoloju-msft
        Community Support
        1 year ago

        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.