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