Forum Discussion
Paginated Report Builder Oracle Data Source Connectivity issues
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.
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?
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.
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!
Trying more, this might help?
https://www.datavail.com/blog/ora-12154-tnscould-not-resolve-the-connect-identifier-specified/
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.
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.
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?
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.
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
