Forum Discussion

aaditya2000's avatar
aaditya2000
Helper II
9 years ago

Power BI Reporting Server Data Source for oracle

Hello:   I am not seeing connection info for Oracle from the drop down & only i see is Oracle Essbase, attached is the screenshot.   I need help how to create Oracle connection\string in Power BI...
Oracle Data Source Issue
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi aaditya2000,

 

I got information below:

 

You have to install the ODAC library and edit rsReportServer.config file to enable the data source extension to show up in the portal.

 

Best Regards,
Qiuyun Yu

pritesho's avatar
pritesho
Helper I
9 years ago

Did this work for you?  I have ODT and ODAC library installed on my machine.

  • aaditya2000's avatar
    aaditya2000
    Helper II
    9 years ago

    I did install but i am not seeing Oracle in my Connection Type?

     

    Thanks

    • pritesho's avatar
      pritesho
      Helper I
      9 years ago

      We are likewise and need Oracle connection

      • riccardomuti's avatar
        riccardomuti
        Microsoft Employee
        9 years ago

        Make sure you've installed the 64-bit version of ODAC (since Power BI Report Server is a 64-bit process), including ODP.NET: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html. Then restart the report server service. Then, if you still don't see Oracle Database in the list, you'll probably find error details in the report server trace log (C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles).