cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aaditya2000 Regular Visitor
Regular Visitor

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

 

Any help is greatly appreciated.

 

Thanks

Regards

Jay

 

 

GVRORA.png

16 REPLIES 16
Moderator v-qiuyu-msft
Moderator

Re: Power BI Reporting Server Data Source for oracle

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
aaditya2000 Regular Visitor
Regular Visitor

Re: Power BI Reporting Server Data Source for oracle

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

Moderator v-qiuyu-msft
Moderator

Re: Power BI Reporting Server Data Source for oracle

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
pritesho Regular Visitor
Regular Visitor

Re: Power BI Reporting Server Data Source for oracle

Did this work for you?  I have ODT and ODAC library installed on my machine.

aaditya2000 Regular Visitor
Regular Visitor

Re: Power BI Reporting Server Data Source for oracle

I did install but i am not seeing Oracle in my Connection Type?

 

Thanks

pritesho Regular Visitor
Regular Visitor

Re: Power BI Reporting Server Data Source for oracle

We are likewise and need Oracle connection

Power BI Team riccardomuti
Power BI Team

Re: Power BI Reporting Server Data Source for oracle

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

Re: Power BI Reporting Server Data Source for oracle

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.

Power BI Team riccardomuti
Power BI Team

Re: Power BI Reporting Server Data Source for oracle

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.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!