Paginated Report Builder Oracle Data Source Connectivity issues

[wandasoozq]

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!!!

[onbi]

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?