Forum Discussion
Paginated Report Builder Oracle Data Source Connectivity issues
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