cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.
Highlighted
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
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 186 members 1,831 guests
Please welcome our newest community members: