topic Re: Paginated Report Builder Oracle Data Source Connectivity issues in Report Server

Paginated Report Builder Oracle Data Source Connectivity issues

Anonymous — Tue, 29 Oct 2019 14:32:22 GMT

Good morning,

I have downloaded the latest version of Paginated Reports (updated 10/28/2019). I have the 64-bit Oracle client installed, and I have no problem connecting to our Oracle datasource in PBI desktop and the service. However, I have been unable to connect to our database from the Report Builder. I have tried various formats of the connection string with no luck. The error I am receiving is "Unable to connect to the data source"...Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.

We have tried this on my current machine (which has both 64 bit and 32 bit installed) as well as a brand new machine with only 64 bit installed. The components were loaded from recommended downloads from PBI and verified.

Any help would be appreciated!!!

Re: Paginated Report Builder Oracle Data Source Connectivity issues

bradsy — Tue, 29 Oct 2019 16:44:24 GMT

Hi wandasoozq,

Report Builder is 32 bit only, so you will definitely need the 32 bit drivers. It has been a little while since I had to configure Oracle, but I do recall it being the full install. I found this on my machine. There is probably a newer version to try.

Oracle Data Provider for .NET, Managed Driver for ODAC 12c Release 4

Re: Paginated Report Builder Oracle Data Source Connectivity issues

Anonymous — Mon, 04 Nov 2019 16:01:37 GMT

Thank you. We have loaded all of the 32-bit drivers and are still unable to connect. We do not get an error message, but the connection attempt keeps churning. I can connect via the PBI desktop/service connections I have established, but I am still not able to do so natively.

Re: Paginated Report Builder Oracle Data Source Connectivity issues

v-jobesa — Tue, 05 Nov 2019 21:31:13 GMT

Hi,

Is this happening with latest version of PowerBI Report Builder v15.0.1517.0 ? Or the older Report Builder for SQL Server 2016?

Re: Paginated Report Builder Oracle Data Source Connectivity issues

Anonymous — Tue, 05 Nov 2019 21:39:27 GMT

Latest version (v15.0.1517.0)...

Re: Paginated Report Builder Oracle Data Source Connectivity issues

v-jobesa — Tue, 05 Nov 2019 22:15:54 GMT

never mind... I see above you installed recent 10/18 version...

Re: Paginated Report Builder Oracle Data Source Connectivity issues

v-jobesa — Tue, 05 Nov 2019 22:19:46 GMT

Can you try the older Report Builder here:

https://www.microsoft.com/en-us/download/details.aspx?id=53613

Your issue might be related to a recently found bug which does not seem to afffect the older Report Builder above.

Re: Paginated Report Builder Oracle Data Source Connectivity issues

Anonymous — Wed, 06 Nov 2019 14:51:03 GMT

I downloaded the older version you suggested, and, out of the box, I am still unable to connect to my Oracle database. However, I am no longer getting the 32-bit/64-bit ODAC error that I was getting before. I am now just getting the normal "unable to connect to data source" error (which could be a lot of different things - version, connection string, drivers). Thank you for the new direction. I will keep trying.

Re: Paginated Report Builder Oracle Data Source Connectivity issues

onbi — Tue, 10 Dec 2019 20:20:27 GMT

Were you successful in connecting to Oracle DB from Power BI Report Builder tool.

If so then, can you please share what had to be done to get it connected to Oracle DB?

Re: Paginated Report Builder Oracle Data Source Connectivity issues

Anonymous — Tue, 10 Dec 2019 20:25:30 GMT

No, unfortunately, we were unable to connect natively. I can connect using the datasources I have set up in PBI desktop, but I still would like to connect the same (easy) way we can in the desktop version. We have another reporting tool that we use, so this has been placed on the back-burner.

Re: Paginated Report Builder Oracle Data Source Connectivity issues

onbi — Tue, 10 Dec 2019 21:27:49 GMT

It's surprising that Microsoft is not providing any support on how to connect this tool to Oracle DB. I've been looking around on how to connect to Power BI Report Builder for a day now and couldn't get proper direction.

Microsoft Support... please help!

Re: Paginated Report Builder Oracle Data Source Connectivity issues

bradsy — Tue, 10 Dec 2019 21:57:23 GMT

This article may help. https://www.codeproject.com/Articles/857489/Creating-Report-using-Report-Builder-and-Oracle-DB

Re: Paginated Report Builder Oracle Data Source Connectivity issues

onbi — Tue, 10 Dec 2019 22:37:45 GMT

Thank you bradsy I tried with the approach mentioned in the article, but the Report Builder tool throws the error ORA-12154: TNS : could not resolve the connect identifier specified.

Not sure, if its the problem with the current version of Power BI Report Builder.

Re: Paginated Report Builder Oracle Data Source Connectivity issues

bradsy — Tue, 10 Dec 2019 22:56:27 GMT

Trying more, this might help?

https://www.datavail.com/blog/ora-12154-tnscould-not-resolve-the-connect-identifier-specified/

Re: Paginated Report Builder Oracle Data Source Connectivity issues

onbi — Tue, 10 Dec 2019 23:16:30 GMT

Thanks once again bradsy I checked the TNS_ADMIN and tnsnames.ora file and it looks correct. Also, I tried from SQL Developer and could connect from the tool as well. I tried connecting to my SQL Plus session using tnsnames.ora file, which exists in the same path set in TNS_ADMIN environment variable.

Not sure, what am I missing here.

Re: Paginated Report Builder Oracle Data Source Connectivity issues

bradsy — Wed, 11 Dec 2019 17:34:46 GMT

We did some more research. It looks like there is a bug with processing new reports that connect to Oracle. Existing reports seem to work fine. We have not figured out where the issue is, but if you have existing reports and you create a new report, check the connection string properties. There may be something there. We will fix for next update, which is looking to be around January time frame.

If you are editing and working with existing reports and having a problem, that is a new issue, let us know.

Re: Paginated Report Builder Oracle Data Source Connectivity issues

onbi — Wed, 11 Dec 2019 17:55:13 GMT

Thanks much bradsy for helping me resolve the issue with Oracle DB connectivity. At present we don't have any existing reports developed in Power BI Report Builder. We're developing first paginated reports using this tool. Is it possible to get the sample conection string if there is one?

But, the question is, since there is a bug within the tool, will the connection string work as well?

Re: Paginated Report Builder Oracle Data Source Connectivity issues

bradsy — Wed, 11 Dec 2019 18:17:45 GMT

The older Report Builder looks to work correctly with Oracle, does not have the bug. Can you try that:

https://www.microsoft.com/en-us/download/details.aspx?id=53613

It does not work with Power BI Server however.

Re: Paginated Report Builder Oracle Data Source Connectivity issues

onbi — Thu, 12 Dec 2019 00:32:37 GMT

Thank you bradsy for the download link of the earlier version of Report Builder. I installed and tried to configure the Oracle connection. However, the "build" button is disabled when "Oracle Database" is selected as Data Source. It seems like the Connection Driver for Oracle is not available in this release

Re: Paginated Report Builder Oracle Data Source Connectivity issues

Anonymous — Tue, 19 May 2020 12:46:37 GMT

We are having the same issue with report builder for report server and an oracle connection. Has the bug been resolved in Report Builder? Thanks