Paginated Reports, Not all variables bound
Greetings, I am working on a paginated report in Power BI Report Builder, and getting the attached error "A data source used by this report returned an error. An exception encountered while accessing the target data source ERROR [07001] [Oracle][ODBC][Ora]ORA-01008: not all variables bound", screenshot shown below. I am using the ODBC(Preview) data source in Report Builder, with a simplified query structure like: SELECT * FROM <table_1> WHERE <field_1> BETWEEN :p_variable_1 AND :p_variable_2 AND (<field_2>= :p_variable_3 or <field_3>= :p_variable_3 or <field_4>= :p_variable_3 or <field_5>= :p_variable_3); If I remove the parameters and hard code the values, the query works fine. I am also able to run the query in SQL Developer without issues, and if I change the Data Source to "Oracle Database" the query also runs without issues. I had initally tried Publshing the paginated report with the Data Source sourse as Oracle Database, which runs on my local machine, but when published to the server I get "A data source used by this report returned an error. An exception encountered while creating the target data source Unable to find the requested .Net Framework Data Provider. It may not be installed." (We have .NET Framework 4.5). It went on to specify Additional steps are required to view this report, which brought me to instructions on setting up and using ODBC, which I took to mean I can only use Paginated Reports with an ODBC Data Source. If that assumption is incorrect I am open to correction, whatever works. TL;DR - Trying to publish a paginated report in Power BI Report Builder using ODBC but encountering "ERROR [07001] [Oracle][ODBC][Ora]ORA-01008: not all variables bound". When using Oracle DB as the Data Source yields "Unable to find the requested .Net Framework Data Provider. It may not be installed". Any help would be appreciated with getting this running. .
PowerBI Report Server Connection to Remote Oracle Database Fails Using Kerberos
Running Power BI Report Server, version 15.0.1113.165 On the report server I have a connection to an Oracle database running on a remote non-Windows server in the same domain that I want to use the current user's credentials (e.g., using Kerberos). This connection fails with an invalid username/password error. It does not appear to be using Kerberos in the attempt. Connections that specify credentials succeed. The report server config file uses RSWindowsNegotiate. The report server runs under a domain service account. The account is configured to allow the delegation. SPNs have been created on the service account. I can't find anything in the logs (Windows and report server) to indicate the problem. Kerberos logging is enabled. When logged on to the machine hosting the report server, I can use SQL*Plus to connect to the Oracle database using Kerberos so that much is working. What am I missing to get the report server to use Kerberos?Paginated Reports with Oracle DB Connection Type
Greetings, I am using Power BI Report Builder to generate a report using Oracle DB as the connection type. It runs fine on my local machine, but when published to the server I get the displayed error when trying to access it. The "Additional steps are required to view this report" link brings me this this page Power BI gateway and Report Builder support for ODBC data sources (preview) - Power BI | Microsoft Docs , which outlines how to configure and use ODBC with paginated reports. We have explored and configured this option, but it does not perform as well as the Oracle DB connection type when connected to our Oracle database. So far we have confirmed the 64 bit ODAC 12.2 is installed on the host server, following the instrutions here [Oracle Connection Type (SSRS & Power BI Report Server) - SQL Server Reporting Services (SSRS) | Microsoft Docs ]to register the ODP.NET Managed Client to both the GAC and machine.config. We have Power BI reports that use the existing Oracle connection just fine on the server, so not sure what next to try in resolving this. Any help will be apreciated, and should more details be required I will provide.
Paginated Report Builder Oracle Data Source Connectivity issues
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!!!
PBIRS Issue with 11g Oracle Database Credentials - logon error
For some strange reason, I can connect to 12c Oracle databases, but when attempting to connect to 11g instances using a PBIRS data source definition, the credentials always fail. The TNS entries are correct and I can build a connection to the database fine, so the drivers are able to connect to the database acrsoss the network... Unfortunately, though, it seems to mangle the password in some way. My username is being sent properly, because it ended up locking my account on the database side after a few attempts. I'm sure the password was correct as well. Even attempted to use different passwords to circumvent any sort of special character issues. Oddly, when using command line on the server running PBIRS, I can use sqlplus to connect to the database without any issue. I have used both the external credential wallet as well as manually typing the username and password. In both cases, I'm able to connect with SQLPlus and when creating and ODBC connection on the server itself. However, when trying to use the drivers utilized by PBIRS to connect my credentials are being passed incorrectly. Any tips?Issue with Oracle connection
Hello everyone, I have a Oracle database as a data source for my report, in my power bi rs desktop version I can refresh data but when I try to deploye my report into the portal for power bi report server I got this error message : An error happened while reading data from the provider: 'Object refrence not set to an instance of an object' I create a data source in the portal just to be sure if the connection between the portal and database it's working well, and effectively it's working successfully. Do you have please any ideas about this topic ?
ORACLE 19
Hi guys, we are using on-premise PBIRS. We installed ORALCE drivers on the server as described in this documentation: https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver15 We used 18.3 version of the driver, because it is what the documentation suggests. All works like charm. Our problem is, we need to use the latest version of the driver, 19.3.1, because that's what we use everywhere else. I tried the above instruction with this version, but the connections to ORACLE end with "connection lost" error. My questions are: Is 19.x version of the drivers supported by Microsoft? If not, when will be the support added? Did anybody of you persuade PBIRS to work with ORACLE 19.x drivers? So far we use paginated reports only, so crucial is to have functional rendering of RDL reports with the latest driver. We do not use OLEDB/ODBC because of various problems - we need ODAC. Thank you, Petr
