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.