topic Power BI Reporting Server Data Source for oracle in Report Server

Power BI Reporting Server Data Source for oracle

aaditya2000 — Sat, 01 Jul 2017 23:34:23 GMT

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

Re: Power BI Reporting Server Data Source for oracle

v-qiuyu-msft — Tue, 04 Jul 2017 09:04:34 GMT

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

Re: Power BI Reporting Server Data Source for oracle

aaditya2000 — Tue, 04 Jul 2017 18:49:09 GMT

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

Re: Power BI Reporting Server Data Source for oracle

v-qiuyu-msft — Wed, 05 Jul 2017 08:31:43 GMT

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

Re: Power BI Reporting Server Data Source for oracle

pritesho — Wed, 19 Jul 2017 17:33:12 GMT

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

Re: Power BI Reporting Server Data Source for oracle

aaditya2000 — Thu, 20 Jul 2017 03:05:02 GMT

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

Thanks

Re: Power BI Reporting Server Data Source for oracle

pritesho — Mon, 28 Aug 2017 15:47:35 GMT

We are likewise and need Oracle connection

Re: Power BI Reporting Server Data Source for oracle

riccardomuti — Tue, 29 Aug 2017 05:08:03 GMT

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

Re: Power BI Reporting Server Data Source for oracle

thiyageshwarans — Fri, 08 Sep 2017 09:41:44 GMT

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.

Re: Power BI Reporting Server Data Source for oracle

riccardomuti — Sat, 09 Sep 2017 00:11:14 GMT

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.

Re: Power BI Reporting Server Data Source for oracle

thiyageshwarans — Mon, 11 Sep 2017 12:48:36 GMT

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?

Re: Power BI Reporting Server Data Source for oracle

riccardomuti — Thu, 14 Sep 2017 23:03:51 GMT

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.

Re: Power BI Reporting Server Data Source for oracle

thiyageshwarans — Mon, 25 Sep 2017 13:58:14 GMT

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?

Re: Power BI Reporting Server Data Source for oracle

riccardomuti — Tue, 26 Sep 2017 05:22:38 GMT

You should be able to use the Oracle Database connector to connect to an Oracle database running in Azure.

Re: Power BI Reporting Server Data Source for oracle

thiyageshwarans — Tue, 26 Sep 2017 06:53:04 GMT

Thanks Riccardo,

Could you please share the sample connection string to connect Azure oracle server

Re: Power BI Reporting Server Data Source for oracle

Anonymous — Thu, 12 Jul 2018 10:36:44 GMT

I need help for connection between reporting server with oracle .see the below image why build button to hide mode I need to connect with oracle and my oracle database on server .

Thanks.

Re: Power BI Reporting Server Data Source for oracle

Anonymous — Thu, 12 Jul 2018 09:54:31 GMT

I need help for Power BI Reporting server Data source for oracle .I am getting Below error when I connect Oracle DataBase.See the Below Image.

Thanks.