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,

 

Currently, the only data source supported for Power BI reports are a live connection to Analysis Services (tabular or multidimensional). More data sources will be added in future releases.

 

Regarding to create a shared Oracle data source in Power BI report server, I will consult this issue internally. Will update here once I get feedback.

 

Best Regards,
Qiuyun Yu

aaditya2000's avatar
aaditya2000
Helper II
9 years ago

Thank you for your reply. we are doing POC for more than 300 users and its all dependent on Oracle data source.

 

Thanks

Regards

Jay

  • 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