Can't connect to Oracle 19 through on prem gateway
We have the 3000.89.6 version of the on prem gateway and are trying to connect to oracle using the 64bit 19.3 ODAC and get the following message when trying to add the datasource. The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.' We have followed the instructions in the git at Oracle ODAC 18 is supported with additional steps · Issue #2147 · MicrosoftDocs/powerbi-docs · GitHub and made sure there was no space between the colon in the .NET version. Any help would be appreciated. We are able to successfully connect from Power BI Desktop installed on the gateway server. The OS is x64, the gateway services should be x64 as well, correct?
Power BI Reporting Server Solution
Our client (Company A) and our project team has faced the difficulties below to deploy Power BI Report server solutions. Can you advise how we can get support on that? Company A ’s Requirement: Due to security concerns, users need to get the data in Company A ’s Oracle DB without directly connecting to Company A ’s Oracle DB. Our current solution: First, we create a Data Source connecting to Oracle DB in Power BI Report Server by using ADO.net Connector with SSL (Oracle Wallet). Then, we create a Dataset using the Data Source. And the last, users use Odata Feed connecter in Power BI Desktop/Excel or Postman to connect to the Dataset with Power BI user authentication with Company A's Active Directory. The problems of current solution: Not able to load data into Power BI Desktop/Excel/Postman from Dataset using Odata when the amount of data is large (Timeout occurred), any sizing guide or limitation on this? Not able to create Data Source connecting to Oracle DB by using ADO.net by SSL with Wallet The additional concerns: Limitations of concurrent user capacity Any other solutions could cope with the need required? Thanks for your advice!
Oracle database connection error in Power BI Report Server - On Premise
Hi, I have created a report in Power BI Desktop August 2018 version. The reports read from Oracle Database and the connection is successfull. I have uploaded the report to an On-Premise Power Bi report server August 2018 version. I want to schedule the data refresh for every 1 hour and when I tried testing the connection, It displays the below error saying "The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.'. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the official provider" The server contains the latest ODAC components including Oracle client 12.2. Also I have added appropriate tnsnames.ORA file in the respective path. Still could'nt figure what is to be done to resolve the error. Kindly provide suggestions. Thanks, MithraError al actualizar datos - Error updating data
Hola Comunidad, Me aparece el error adjunto cuando hago la actualizacion de mis datos, no se si es un error de la conexion de la puerta de enlace o de la conexion con la data de Oracle. Pero ya he intentado de todo y no funciona. ---------------- Hi Community, I get the attached error when I update my data, I don't know if it is an error in the connection of the gateway or the connection with the Oracle data. But I have already tried everything and it doesn't work. Thanks.
