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
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).

    • thiyageshwarans's avatar
      thiyageshwarans
      Frequent Visitor
      8 years ago

      Hi Riccardo,
      As you said, i have installed 64-bit version of ODAC including ODP.NET in my machine, After restarting the powerBI reporting service, i can select the oracle database in power bi report web page and i have created the oracle database connection, eventually it got succeded, but i couldn't create a dataset using this datasource, i'm getting TNS - ora identifier issue, while i'm connectig via report builder3.0.

      • riccardomuti's avatar
        riccardomuti
        Microsoft Employee
        8 years ago

        Whereas the report server is 64-bit, the client tools (Report Builder and Visual Studio) are 32-bit, so on the client side, you need the 32-bit version of ODAC/ODP.NET.