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

  • thiyageshwarans's avatar
    thiyageshwarans
    Frequent Visitor
    8 years ago

    Hi Riccardo,

    Thanks for you reply!!!

    FYI, I'm using windows 10 Pro, I can connect oracle database using oracle client, so there is no issue in TNS names.
    As you said, I have removed 64-bit ODAC and ODP.Net from my machine and installed 32-bit ODAC/ODP Versions, this time i couldn't connect even datasource itself.

    Please let me know is there any restrictions/specification on Power BI report server while connecting to oracle server?

  • riccardomuti's avatar
    riccardomuti
    Microsoft Employee
    8 years ago

    Hmm, sorry you're still having trouble. At this point, it's difficult to know what might be missing without investigating hands-on. Could you open a case with Microsoft Support so we can do so? It'd be great to get to the bottom of it and improve our documentation if necessary.

  • thiyageshwarans's avatar
    thiyageshwarans
    Frequent Visitor
    8 years ago

    Hi Team,

    i can connect on premise oracle databse using power BI reporting server. Thanks for you help team.

     

    Now i'm facing new issue, could i connect Microsoft azure oracle using power BI report server

     

    Beacuse , there is no option to select the azure oracle data source connection type in power BI report server?

     

  • riccardomuti's avatar
    riccardomuti
    Microsoft Employee
    8 years ago

    You should be able to use the Oracle Database connector to connect to an Oracle database running in Azure.

  • thiyageshwarans's avatar
    thiyageshwarans
    Frequent Visitor
    8 years ago

    Thanks Riccardo,

     

    Could you please share the sample connection string to connect Azure oracle server

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi

        I need help for Power BI Reporting server Data source for oracle .I am getting Below error when I connect Oracle DataBase.See the Below Image.

     

    Thanks.