Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Paginated Report Builder Oracle Data Source Connectivity issues

Good morning,

 

I have downloaded the latest version of Paginated Reports (updated 10/28/2019). I have the 64-bit Oracle client installed, and I have no problem connecting to our Oracle datasource in PBI desktop and the service. However, I have been unable to connect to our database from the Report Builder. I have tried various formats of the connection string with no luck. The error I am receiving is "Unable to connect to the data source"...Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.

 

We have tried this on my current machine (which has both 64 bit and 32 bit installed) as well as a brand new machine with only 64 bit installed. The components were loaded from recommended downloads from PBI and verified.

 

Any help would be appreciated!!!

 

Oracle Data Source Issue
Paginated Report Builder

21 Replies

  • bradsy's avatar
    bradsy
    Microsoft Employee
    6 years ago

    Hi wandasoozq,

     

    Report Builder is 32 bit only, so you will definitely need the 32 bit drivers. It has been a little while since I had to configure Oracle, but I do recall it being the full install. I found this on my machine. There is probably a newer version to try.

    Oracle Data Provider for .NET, Managed Driver for ODAC 12c Release 4

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you. We have loaded all of the 32-bit drivers and are still unable to connect. We do not get an error message, but the connection attempt keeps churning. I can connect via the PBI desktop/service connections I have established, but I am still not able to do so natively.

      • v-jobesa's avatar
        v-jobesa
        New Member
        6 years ago

        Hi,

         

        Is this happening with latest version of PowerBI Report Builder v15.0.1517.0 ? Or the older Report Builder for SQL Server 2016?

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    We are having the same issue with report builder for report server and an oracle connection.  Has the bug been resolved in Report Builder?  Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    i had same problem on 64bit laptop

     

    i found this: https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver15

     

    after doing these steps

    32-bit drivers for Report Builder

    Report Builder uses Managed ODP.NET for authoring paginated reports. The following steps are only needed when using Oracle ODAC drivers 12.2 and later as they install by default to a non-machine-wide configuration for a new Oracle home installation. These steps assume you've installed the ODAC 18.x files to c:\oracle32 and the file version of your Oracle.ManagedDataAccess.dll is 4.122.18.3.

    1. On the Oracle download site, install the oracle 32 bit odac Oracle UI

    2. Register ODP.NET Managed Client to GAC:

      C:\oracle32\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:gac /providerpath:C:\oracle32\product\18.0.0\client_1\odp.net\managed\common\Oracle.ManagedDataAccess.dll

    3. Add ODP.NET Managed Client entries to machine.config:

      C:\oracle32\product\18.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:config /force /product:odpm /frameworkversion:v4.0.30319 /productversion:4.122.18.3

    Then i added all my oracles connections into TNSNAMESORA and PBI report builder works fine now for oracle connections