Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI Report Server, Report Builder and Oracle Connection

We are unable to connect to an Oracle database from our on prem Power BI Report Server using Desktop with Direct Query or with Report Builder's Paginated reports.  The Oracle connection test connecti...
oracle
report builder
Report Server
  • Anonymous's avatar
    Anonymous
    6 years ago

    We have the oracle client installed with the associated TNS names file setup.  

     

    C:\ora32\product\12.1.0\client_1\network\admin

     

    Tnsnames.ora file contains the following:

    # tnsnames.ora Network Configuration File: C:\Oracle\product\10.1.0\Client_1\NETWORK\ADMIN\tnsnames.ora

    # Generated by Oracle configuration tools.

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , on the report server, is oracle database connector is installed ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    We have the oracle client installed with the associated TNS names file setup.  

     

    C:\ora32\product\12.1.0\client_1\network\admin

     

    Tnsnames.ora file contains the following:

    # tnsnames.ora Network Configuration File: C:\Oracle\product\10.1.0\Client_1\NETWORK\ADMIN\tnsnames.ora

    # Generated by Oracle configuration tools.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      That did the trick.  Thanks!